topic Formula to ignore selection in QlikView

Formula to ignore selection

sweens78 — Thu, 17 Jan 2019 12:28:10 GMT

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

Re: Formula to ignore selection

Gabriel — Thu, 17 Jan 2019 12:32:18 GMT

Hi,

Try this Count( {1} PatientsNotAssessed_ID)

The 1 there should ignore all selections

Re: Formula to ignore selection

sweens78 — Thu, 17 Jan 2019 12:41:48 GMT

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

Re: Formula to ignore selection

Gabriel — Thu, 17 Jan 2019 12:45:47 GMT

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.

Re: Formula to ignore selection

sweens78 — Thu, 17 Jan 2019 13:42:38 GMT

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

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