Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sonikajain
Partner - Contributor
Partner - Contributor

displaying selected values or 'ALL' in a table

Hi all,  I am stuck in a scenario where I have a table like the one below.

DivisionSub DivisionCATEGORYDESCRIPTIONsum(BALANCE)
DIV1SEC2UTILITIESWater &   Electricity600000
SEC3UTILITIESWater &   Electricity600000
SEC4UTILITIESWater &   Electricity600000
SEC6POSTAGEPostage &   Courier 1120000
DIV2MAILPOSTAGEPostage &   Courier 1120000
SEC1UTILITIESTelephones, Internet   & Satellite Services1040000
SEC1UTILITIESWater &   Electricity600000
DIV3SEC6SUBSCRIPTIONNewspapers &   Periodicals1050000
DIV4DSXUTILITIESWater &   Electricity600000
DIV5MANAGEMENTSUBSCRIPTIONNewspapers &   Periodicals1050000
WEBSUBSCRIPTIONNewspapers &   Periodicals1050000
DIV6MANAGEMENTSUBSCRIPTIONNewspapers &   Periodicals1050000

Now , I want to display the values that are selected(highlighted in green) for Division, subdivision,category,description in the form of a table, and for the columns that are not been selected, it should display 'ALL'. I know that there is a 'current selections box' available in Qlikview, but that would display only the selected values, and not all of them(that too with text like 'ALL').

For Example,when I select Division and subdivision , I should get something like the box below.

DivisionDIV1
Sub DivisionSEC2
CATEGORYALL
DESCRIPTIONALL

Please help me in implementing this.
Thanks in advance.

2 Replies
Jason_Michaelides
Partner - Master II
Partner - Master II

If you only want to do this for a few fields I'd probably use a series of text boxes - one for the field name and the other with an expression like:

=IF(GetSelectedCount(YourField)=Count({1}DISTINCT YourField),'ALL',Concat(DISTINCT YourField,', '))

Hope this helps,

Jason

Jason_Michaelides
Partner - Master II
Partner - Master II

Oops - just te-read your requirements. Change GetSelectedCount() for GetPossibleCount()