topic Re: Ignoring the date field's selection in QlikView

Ignoring the date field's selection

Fri, 20 Jan 2012 16:33:37 GMT

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

Ignoring the date field's selection

Fri, 20 Jan 2012 17:01:22 GMT

You can use set analysis:

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

Ignoring the date field's selection

Mon, 23 Jan 2012 16:59:18 GMT

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

Re: Ignoring the date field's selection

Mon, 23 Jan 2012 19:16:37 GMT

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 !