topic Re: Dropdown based on Columns in data in QlikView

Dropdown based on Columns in data

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have to sum the spend based on the selection of continent ,country and city from a single drop down and one of category should be selected by default .

Second, user should be able to drill down as well

for eg user has selected continent in the drop down, and sum will be based on continent . Then user click on one continent,and he should be able to drill down to countries in that particular continent . Further he can drill down to cities as well and sum should be based on cities.

Hope i am clear with this. Attaching the table and qvw file.

Re: Dropdown based on Columns in data

vishsaggi — Fri, 12 Aug 2016 20:12:39 GMT

You want this as a Bar Graph or a Table chart.

Check this?

Re: Dropdown based on Columns in data

trdandamudi — Fri, 12 Aug 2016 20:18:47 GMT

See if the below helps:

Re: Dropdown based on Columns in data

Mon, 15 Aug 2016 18:23:29 GMT

Actually i am looking this in a dropdown rather than on a column header .

Is it possible?

Re: Dropdown based on Columns in data

trdandamudi — Mon, 15 Aug 2016 19:09:10 GMT

See if the attached works for you which has the drop down list box...

Re: Dropdown based on Columns in data

trdandamudi — Mon, 15 Aug 2016 19:12:06 GMT

You can also do one more way... Please see the attached:

Re: Dropdown based on Columns in data

Tue, 16 Aug 2016 18:42:49 GMT

Actually i am looking like given in attached in the image.

1) Based upon selection of metric, Table should be aggregated

2) when i click on single row, it should be drill into countries

Re: Dropdown based on Columns in data

Tue, 16 Aug 2016 18:43:49 GMT

Actually i am looking like given in attached in the image.

1) Based upon selection of metric, Table should be aggregated

2) when i click on single row, it should be drill into countries