If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have to exclude from all range of possible values combination of two in measure. Basically I need to sum all but year 2016 and month 5 and Total for field Amount should be 9.
I need solution with set analysis as in real data there are much more combinations and more conditions.
at the moment tried something like this but it doesn't help
So the question is really about syntax.
I tried the above logic with the sample Qlikview Data. But it is not working and i donot know why. Attached Excel and QLikview app for your reference. I am using Personalized edition and only in office we used licensed. So , i cannot open the changes that u make in attached Qlikview. Kindly share the expression in the comment itself. !Sorry to trouble u ..@