displaying selected values or 'ALL' in a table

sonikajain — Thu, 19 Apr 2012 20:35:16 GMT

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

Division	Sub Division	CATEGORY	DESCRIPTION	sum(BALANCE)
DIV1	SEC2	UTILITIES	Water & Electricity	600000
	SEC3	UTILITIES	Water & Electricity	600000
	SEC4	UTILITIES	Water & Electricity	600000
	SEC6	POSTAGE	Postage & Courier	1120000
DIV2	MAIL	POSTAGE	Postage & Courier	1120000
	SEC1	UTILITIES	Telephones, Internet & Satellite Services	1040000
	SEC1	UTILITIES	Water & Electricity	600000
DIV3	SEC6	SUBSCRIPTION	Newspapers & Periodicals	1050000
DIV4	DSX	UTILITIES	Water & Electricity	600000
DIV5	MANAGEMENT	SUBSCRIPTION	Newspapers & Periodicals	1050000
DIV5	WEB	SUBSCRIPTION	Newspapers & Periodicals	1050000
DIV6	MANAGEMENT	SUBSCRIPTION	Newspapers & Periodicals	1050000

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.

Division	DIV1
Sub Division	SEC2
CATEGORY	ALL
DESCRIPTION	ALL

Please help me in implementing this.
Thanks in advance.

displaying selected values or 'ALL' in a table

Jason_Michaelides — Thu, 19 Apr 2012 22:49:46 GMT

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

displaying selected values or 'ALL' in a table

Jason_Michaelides — Thu, 19 Apr 2012 22:58:56 GMT

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

topic displaying selected values or 'ALL' in a table in QlikView

displaying selected values or 'ALL' in a table

displaying selected values or 'ALL' in a table

displaying selected values or 'ALL' in a table