Ignore Selection in straight table with no expressions

[femi_owoseni]

Hi,

I have a detail Table with no expressions in it as no aggregation is required but I would like the table to ignore current selections.

How can this be achieved in Qlik sense ?

Thanks,

Femi

[sunny_talwar · Accepted solution]

May be create a dummy expression just so that you can ignore selections?

Sum({1} 1)

or use alternate states

Alternate States in Qlik Sense

[OmarBenSalem]

In the new qlik sense version, u can add a column in a table and not show it

+ alternate states is  built-in, no need for an extension to achieve it 

see:

https://www.youtube.com/watch?v=t2JWSzFVwh8

[sunny_talwar]

Awesome 🙂

[femi_owoseni]

Thanks Sunny,

I created the dummy expression like you suggested then I hid the column using the "Show column if" and it works.

[sunny_talwar]

Super

[lalita_sharma]

Hi Sunny

I am working on a similar example where I have an dummy expression like below as a table measure

=Sum({$<[Workstream Id]={$(vCalc_StatusPack_DefaultWorkstreamID)},[KPI name]={3},Date=, [M0 Finish Month]=>} 1)

This works as expected. It will show only records with default workstream Id and KPI name 3 and also ignore any selections in Date and M0 Finish Month fields.

But now I want the default workstream filter only when no selections are made on workstream, So I added If condition to my expression as below

=IF(GetSelectedCount(Workstream)=0,
Sum({$<[Workstream Id]={$(vCalc_StatusPack_DefaultWorkstreamID)},[KPI name]={3},Date=, [M0 Finish Month]=>} 1),
Sum({$<[KPI name]={3},Date=, [M0 Finish Month]=>} 1))

I want this expression to display on default workstream when no selections are made on workstream field and display data for selected workstream when a selection is made on workstream.

But when no selection is made on workstream it displays all workstreams.

Any idea why?

[sunny_talwar]

I don't see a reason for it to not work. Would you be able to share a sample to check this out?