Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignoring the date field's selection

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....

1 Solution

Accepted Solutions
Not applicable
Author

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 !

View solution in original post

3 Replies
Not applicable
Author

You can use set analysis:

Count(distinct {1} ID) to ignore all selections.

Not applicable
Author

Is it possible to ignore only one field? instead of all fields?

Not applicable
Author

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 !