Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hhajjali
Contributor III
Contributor III

Ignore filters in tables*

Hello,

I am working in Qlik Sense.

In my application I have a whole of date by RELEASE. Usually I need to see only one release data, so I am using a filter to get my results.

But I am trying to create a table on the last sheet of my application which is a summary of all the releases, and I want it to ignore the selected release in my filter.

The main dimension are date (no relation with release), I tried use set analysis to ignore the filter with no success : 


MESURE: = Count(RELEASE={*},[SLA]={"OK"},[END DATE]-={""},[CUST]={"YES"},[PRIO]={"P3"}>}

if([DATE REF.autoCalendar.YearMonth]=[END DATE.autoCalendar.YearMonth],KEY))

any ideas? Thanks in advance.

3 Replies
devarasu07
Master II
Master II

Hi,

Try like this,

if([DATE REF.autoCalendar.YearMonth]=[END DATE.autoCalendar.YearMonth],

Count( distinct {$<RELEASE=,[SLA]={'OK'},[END DATE]-={"=len(trim([END DATE]))<=0"},[CUST]={'YES'},[PRIO]={'P3'}>} KEY )

also refer to the attached set analysis basics

Set Analysis: syntaxes, examples

P.S we still can simplify the above expression if you provide mock data and expected output in excel format.

Thanks,

Deva

sunny_talwar

Your Measure look right to me... unless you have nulls in Release or you are using a calculated dimension which might be causing issue... are you seeing release drilling down to a specific release when you select a single release? or is the expression just giving you an error?

hhajjali
Contributor III
Contributor III
Author

Hello,

In fact Sunny have reason, my mesure is OK,  but I have filtered on other dimension other than release that conduct me in error. To resolve I just added the other dim filter I used.

Thanks Devarsu for he documents!