displaying selected values or 'ALL' in a table

[sonikajain]

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
	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.

[Jason_Michaelides]

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]

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