Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

filtering through set analysis.

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

Tags (1)
18 Replies

Re: filtering through set analysis.

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


talk is cheap, supply exceeds demand
Not applicable

Re: filtering through set analysis.

Hi wassenaar,

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

MVP
MVP

Re: filtering through set analysis.

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.

Re: filtering through set analysis.

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


talk is cheap, supply exceeds demand
Not applicable

Re: filtering through set analysis.

it is showing display in both the scenarios

sunilkumarqv
Valued Contributor II

Re: filtering through set analysis.

If you dont want to filter client

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

Not applicable

Re: filtering through set analysis.

i tried it is not working.

Not applicable

Re: filtering through set analysis.

wassenaar, i tried it it's not working.

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

Re: filtering through set analysis.

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?


talk is cheap, supply exceeds demand