Qlik Set Analysis Not Equal
I want to see the sales where produce category is not shoes.
Qlik set analysis not equal. Hi all the values for field type is a b and c sum total i want to filter the data of a. Sum flag x amount this is not working properly. I am trying to use set analysis for a not equal to value. Qlik catalog documents videos.
I have tried to follow these to do a count based on all values where the field called obac status is not equal to duplicates. But its not 632906. There are a number of discussion on this forum about this topic. Qlik catalog documents videos.
This is just quick question. It works fine if i use count distinct telephone count obac status duplicates distinct teleph. Not equal in set analysis is written as following for example. Sum product category shoes sales i can walk on water when it freezes.
When i change to just i get the correct amount for the ones that should be equal to x. I m looking for the good syntaxe in set analysis to have the not equal expression. So i have written the above modifier. Qlik catalog formerly known as qlik data catalyst qlik catalog discussions.
How should i write this to sum the amount where the flag is not equal to x. Qlik catalog formerly known as qlik data catalyst qlik catalog discussions. Sum produce category shoes sales or.