Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
For example:
Year | Month | Amount |
---|---|---|
2015 | 5 | 1 |
2016 | 5 | 2 |
2015 | 4 | 3 |
2016 | 7 | 5 |
at the moment tried something like this but it doesn't help
Sum({-<Month={5}>*<Year={2016}>} Amount)
Sum({$-<Month={5}>*<Year={2016}>} Amount)
Sum({$}-{<Month={5}>*<Year={2016}>} Amount)
Sum(-{<Month={5}>*<Year={2016}>} Amount)
So the question is really about syntax.
Both of them seems to be working in Qlik Sense also
May be just this
=Sum({$-<Month = {5}, Year = {2016}>} Amount)
Or this
=Sum({-(<Month={5}>*<Year={2016}>)} Amount)
Hi Sunny,
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 ..@
Try this:
Sum({(<Month-={5}, Year-={2016}>)} Amount)
No luck for me Padmaja, some how it is not working and i donot know the actual reason.
=sum({(<[Purchase month]-={2}>)}[Sales Value]) . not working !!!!
For the sample data provided, it seems to work well
Non of these helps. Probably you test it in Qlik View and I use Qlik Sense.
All responses tested - not working.
Both of them seems to be working in Qlik Sense also
Thank you! I will do further investigations. On simple data it works and I see that syntax is right. By some reason on my actual data it doesn't work.