Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the expression of a chart, how do you disregard selections of the date field?
In one particular expression,
I want to count( distinct ID) but disregard what the user selects in the date field, so that it's always the same value no matter what date the user selects.I'm guessing set analysis but not sure how exactly this works....
hello,
you can check out my reply in this message:
http://community.qlik.com/message/184471#184471
where you can also find DV's reply if you want to go the other way which is ignoring all selections except some.
the below document details it too with additional interesting alternatives:
http://community.qlik.com/docs/DOC-1334
Hope this will prove useful !
You can use set analysis:
Count(distinct {1} ID) to ignore all selections.
Is it possible to ignore only one field? instead of all fields?
hello,
you can check out my reply in this message:
http://community.qlik.com/message/184471#184471
where you can also find DV's reply if you want to go the other way which is ignoring all selections except some.
the below document details it too with additional interesting alternatives:
http://community.qlik.com/docs/DOC-1334
Hope this will prove useful !