How to use raw headers in excel as drop box

[Anonymous]

Hi,

I want to use the below raw data table headers as a drop box list

Drop list should be like this: so by clicking < 90, only <90 data will show up and the others should disappear, and so on..

<   90

91 - 180

> 181

Month	Branch	Customer name	Type	Received Amt	< 90	91 - 180	> 181
Jul	Saudi	BUSINESS SOM	Contract	245,381	243,635	0	1,746
Jul	Saudi	ETIMAD	Contract	101,725	118,711	0	0
Jul	Saudi	BRANCH	Direct	60,855	58,855	2,000	0
Jul	UK	NATIONAL CONTRACT	Direct	316,387	0	97,474	218,913
Aug	USA	BETONG	Banking	250,000	250,000	0	0
Aug	USA	ALUMINIUM COMP	Banking	17,089	17,089	0	0
Aug	UK	SARIFC	Banking	250,000	1,200	248,800	0
Aug	UK	Trust	Direct	53,772	0	53,772	0

[ankit777]

Hi,

Are you trying to show/hide the columns in table, based on selection from the field which will have those headers value?

[Anonymous]

yes

I want to create drop box as

< 90

91 - 180

> 181

instead of showing the values that under  < 90

<   90
243,635
118,711
58,855
0
250,000
17,089
1,200
0

[Anonymous]

Any help !!
New to QlikView‌

How to use raw headers in excel as drop box‌

‌

[marcus_sommer]

Your table is a crosstable and you need to transform it - try:

crosstable:

crosstable(DropList, Amounts, 5) Load * From SourceFile;

and you will get two columns - one with your selectable droplist and one with the amounts for them - instead of your native three blue columns.

What it is and how it worked, see: The Crosstable Load.

- Marcus

[Anonymous]

Thanks Marcus. Could you elaborate further! how can this be applied, using the top table!

Please explain the steps. Thanks

[marcus_sommer · Accepted solution]

If you used my suggestion from above you need only to put your first four columns into a pivot-chart and adds sum(Amounts) as expression and DropList as new Listbox-Field (and/or as addditionaly dimension within the chart).

- Marcus