topic Re: How to use raw headers in excel as drop box in QlikView

How to use raw headers in excel as drop box

Anonymous — Thu, 03 Sep 2015 07:00:46 GMT

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

Re: How to use raw headers in excel as drop box

ankit777 — Thu, 03 Sep 2015 08:10:54 GMT

Hi,

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

Re: How to use raw headers in excel as drop box

Anonymous — Thu, 03 Sep 2015 08:23:28 GMT

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

Re: How to use raw headers in excel as drop box

Anonymous — Sun, 06 Sep 2015 08:16:09 GMT

Any help !!
New to QlikView‌

How to use raw headers in excel as drop box‌

‌

Re: How to use raw headers in excel as drop box

marcus_sommer — Sun, 06 Sep 2015 09:12:05 GMT

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

Re: How to use raw headers in excel as drop box

Anonymous — Sun, 06 Sep 2015 12:46:47 GMT

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

Please explain the steps. Thanks

Re: How to use raw headers in excel as drop box

marcus_sommer — Sun, 06 Sep 2015 12:56:45 GMT

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