Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sweens78
Creator
Creator

Formula to ignore selection

Hi Guys,

 

I'm just looking for a formula that will ignore a selection when clicked so for example for the below

dimension is

 

=valuelist($(vdashboardtable))

and within this is an expression

Count(PatientsNotAssessed_ID) 

How would I change this formula so that it still displays results before the selection is made.

So for example if they click a particular hospital the overall value will still display in a different column?

 

Martin

4 Replies
Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

 

Try this Count( {1} PatientsNotAssessed_ID)

The 1 there should ignore all selections

sweens78
Creator
Creator
Author

That's great Gabriel, can you explain how this works, why {1}?
Gabriel
Partner - Specialist III
Partner - Specialist III

The 1 in the Set just say give me all values in the data model same as ignore selections.

 

Please mark if answer is correct for the benefit of someone else.

sweens78
Creator
Creator
Author

I have a formula below Gabriel I tried putting {1} after count but geeting error is this different?

Num (Count(PatientsNotAssessed_ID)/count([NEWKEYID]),'##.#%'),