filtering through set analysis.

[#1]

Hi all,

I have a 4 KPI's in my sheet and two filter pane.

each one refers to the different counts and filter pane is for client and batch.

when i filter through the client filter pane the count shows only for that client.

i have a different start date for the different clients/batch. when i select the particular client the data should filter.

like >= startdate of that client/batch.

and without any filter it should show the all the values.

How can i use the set analysis?

Currently i am using below expression :  Count({$<DateType = {invitation}>}invitation_id)

I tried with the new expression :  Count({$<DateType = {invitation}, canonicaldate = {'>=date(start_date)'}>}invitation_id)

It's working for client specific, but without client specific i need all the counts.

Regards,

Pramod

[Gysbert_Wassenaar]

The set of a set analysis expression is calculated at the chart level, not the row level. If you trying to compare fields of the same record the you may run into problems. See this document for more information: set_analysis_intra-record.qvw

[#3]

Hi wassenaar,

i am using qlik sense, in the above qvw file i am not able to find any sheets.

[jagan]

Hi,

Try like this

I think you have multiple start_dates if you do not select client, for this use max in set analysis like below

Count({$<DateType = {invitation}, canonicaldate = {'>=date(Max(start_date))'}>}invitation_id)

Regards,

jagan.

[Gysbert_Wassenaar]

Ah, good point. I'll have to create a qlik sense document about it. Short story long, if you don't have a field that uniquely identifies the detail record then you will have to use if statements instead of set analysis. Something like count({<DateType={invitation}>} if(canonicaldate > start_date, invitation_id))

[#6]

it is showing display in both the scenarios

[sunilkumarqv]

If you dont want to filter client

Count({$<DateType = {invitation}, canonicaldate = {'>=date(start_date)'},Client=>}invitation_id)

[#8]

i tried it is not working.

[#9]

wassenaar, i tried it it's not working.

the start_date filter should apply only when the client/batch is selected.

[Gysbert_Wassenaar]

I'm afraid I don't understand what you're trying to do. Can you post a small Qlik Sense app that illustrates the problem?