Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 | 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.
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
Oops - just te-read your requirements. Change GetSelectedCount() for GetPossibleCount()