Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
stjernvd
Partner - Creator
Partner - Creator

GetCurrentSelections function that excludes two filters

Hi,

For the Label and Conditional show of an expression in my chart I have the following expressions:

Label: =GetCurrentSelections()


Conditional: =Len(Trim(GetCurrentSelections())> 0)

However, I want to exclude the filters 'KPIs' and 'Sheet', so that when values are selected in these fields, they don't show up in my GetCurrentSelections() function. Is this possible?

2 Replies
Not applicable

Hi,

you could load the fields you don't want showing up with a hide prefix

in you script add something like this

SET HidePrefix = % ;


load

KPIs as %KPI…..

Once you load the field name with the hide prefix in this case % any selections in that field will not appear in your get currentselection() expression

marcus_sommer
MVP & Luminary
MVP & Luminary

The suggestion from sana.ismail is the easiest way and might be exactly want you need but it meant also that selections in those fields won't be displayed within the current selection box and within a dimension-choice by creating or maintaining an object you will need to enable the show system-field option to get access to them.

- Marcus