Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

williamfuu
Contributor II

"Keep" filter selections after clearing

Let's say I'd like to filter the sample table below for all the ID's that had were late on 01/01/2018.

 

DateIDStatus
01/12/2017APending
01/12/2017BPending
01/12/2017CPending
01/01/2018ALate
01/01/2018BOn Time
01/01/2018CLate
01/02/2018ALate
01/02/2018BOn Time
01/02/2018COn Time
01/03/2018AOn Time
01/03/2018B

On Time

The steps to do it manually in Qlik are pretty straightforward:

1. Filter Status = 'Late' and Date='01/01/2018'

2. Filter eligible IDs (A and C)

3. Clear selections on Status and Date fields to get the required rows:

 

DateIDStatus
01/12/2017APending
01/12/2017CPending
01/01/2018ALate
01/01/2018CLate
01/02/2018ALate
01/02/2018COn Time
01/03/2018AOn Time


I'm looking for a way to do this without the manual steps, where the user can just choose the desired date and status and view the filtered table.

I can't seem to figure out how to apply these filters a measure without including unwanted data


The SQL analogy would be:

SELECT * FROM Table WHERE ID IN (SELECT ID FROM Table WHERE Date = '01/01/2018' AND Status = 'Late')

9 Replies
thakkarrahul01
Contributor

Re: "Keep" filter selections after clearing

Hi William,

Based on your stated steps, I have tried to apply selection using Actions on Button(QlikView). Please find attached app & snap.

Regards,

Rahul

MVP
MVP

Re: "Keep" filter selections after clearing

Create a table with ID, Date, Status as dimensions

Then use the expression

=If(Len(Only({<ID = P(ID), Date, Status>} ID)) > 0, 1, 0)


Make sure that suppress zeroes is enabled. In QV you can hide the expression. I am not sure about how you do that in QS.

Capture.PNG

YoussefBelloum
Esteemed Contributor

Re: "Keep" filter selections after clearing

new feature of hiding expression only available on pivot table

agigliotti
Honored Contributor II

Re: "Keep" filter selections after clearing

are you talking about qlik sense april 2018 version?

YoussefBelloum
Esteemed Contributor

Re: "Keep" filter selections after clearing

I'm talking about the latest versions, not specifically April version, because I saw Michael's tarallo keynote and I read the relases notes and it wasn't mentioned there, so I think It was present before April release

agigliotti
Honored Contributor II

Re: "Keep" filter selections after clearing

because i can't find that feature (hiding pivot dimension/measure) even in april 2018 version.

YoussefBelloum
Esteemed Contributor

Re: "Keep" filter selections after clearing

From the office, for Qliksense, I use Qliksense Cloud..

it is called: Object table column visibility condition (unser the measure properties)

Object table columns visibility condition.png

Maybe it is not yet available in Desktop versions...

agigliotti
Honored Contributor II

Re: "Keep" filter selections after clearing

yes I checked on Qlik Cloud right now and I have for all table columns as below:

image01.png

this feature is not included in april 2018 desktop version yet.

did anyone check on  Sense Server april 2018 version ?

williamfuu
Contributor II

Re: "Keep" filter selections after clearing

Hey jontydkpi

Thanks for the response;

I've tested your suggestion and, correct me if I'm wrong, but this seems to stop working if "ID" is not one of the dimensions in the table (e.g. if I wanted a summary of status per date, for example)

Community Browser