topic Re: Count of IDs based on filter selection. in QlikView

Count of IDs based on filter selection.

Anonymous — Sat, 07 Oct 2017 10:32:31 GMT

Hi All,

Consider the below scenario ,

test:

Load * inline

[

Id, date

1,1/2/2016

2,2/4/2017

3,3/3/2016

];

and calendar table where date is key field.

Suppose I have filters like quarters, year , month. If I select any year (2016), it should display count ids which have dates greater than the current selected year. Same logic would be for month filter as well.

i would be thankful if Any one can help me on this

Re: Count of IDs based on filter selection.

its_anandrjs — Sat, 07 Oct 2017 17:05:58 GMT

Try with Set analysis in the expression

Count({< Year = { "$(=GetFieldSelections(Year)-1)" }>} id)

Re: Count of IDs based on filter selection.

Anonymous — Sun, 08 Oct 2017 04:02:23 GMT

Hi Anand,

Thanks for your response.

The solution provided is not serving the purpose.I will play with the expressions and see if i can get solution

Refer the screenshot below.

This image represents data with no selection.

When I select year as 2016, there are 4 records with date as 2016. Desired output should be count ids greater than 2016. i.e 2.

Same way when i select month filter it should display count of ids greater than the month selected. Should be Dynamic.

Please let know if there is any way

Thanks in advance for the help.

Re: Count of IDs based on filter selection.

Frank_Hartmann — Sun, 08 Oct 2017 08:29:55 GMT

whats the format of your datefield?

Re: Count of IDs based on filter selection.

Anonymous — Sun, 08 Oct 2017 12:34:08 GMT

DD/MM/YYYY is the format