Qlik Community

Qlik Sense Documents

Documents about Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER

Creating a Custom Selections Box in QlikView and Qlik Sense

Contributor III
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 ?

0 Likes
Contributor III
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.

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