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