Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Creating a Custom Selections Box in QlikView and Qlik Sense

amityehoclimber
New Contributor III

Creating a Custom Selections Box in QlikView and Qlik Sense

Do you hate QlikView's Current Selections box!?

Do you hate the green bulletins next to the selections!?

Do you want to have your application to show the Current Selection box in an elegant manner!!!???

Well... NOW YOU CAN!!!!!

Here is the Custom Selection Box!!!

You just need 1 hidden dimension, 2 expressions and a straight table!

These are the dimensions and expressions:

1) hidden dimension:

=ValueList($(=Chr(39) & GetCurrentSelections(Chr(39) & Chr(44) & Chr(39), '|', Chr(59)) & Chr(39)))

2) Filters:

=SubField(ValueList($(=Chr(39) & GetCurrentSelections(Chr(39) & Chr(44) & Chr(39), '|', Chr(59)) & Chr(39))), '|', 1)

3) Selections:

=SubField(ValueList($(=Chr(39) & GetCurrentSelections(Chr(39) & Chr(44) & Chr(39), '|', Chr(59)) & Chr(39))), '|', 2)


current Selections.PNG


Attachments
Comments
Employee
Employee

any way to hide the column headers ?

amityehoclimber
New Contributor III

To remove the Caption:

Right click on object --> Properties... --> Caption Tab --> uncheck "Show Caption"

To remove the column headers:

Right click on object --> Properties... --> Presentation Tab --> check "Surpress Header Row"

You welcome.

Version history
Revision #:
1 of 1
Last update:
‎02-08-2017 10:16 AM
Updated by: