This content has been marked as final. Show 2 replies
Hi all, I am stuck in a scenario where I have a table like the one below.
|DIV1||SEC2||UTILITIES||Water & Electricity||600000|
|SEC3||UTILITIES||Water & Electricity||600000|
|SEC4||UTILITIES||Water & Electricity||600000|
|SEC6||POSTAGE||Postage & Courier||1120000|
|DIV2||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.
Please help me in implementing this.
Thanks in advance.