topic Re: Data island in QlikView

Data island

gauthamchilled — Wed, 19 Aug 2015 09:20:36 GMT

I have a data island like the following

Tab1:

Load * inline
[Period
Quarter,
Half Year,
YeartoDate
];

and calendar table separately.

i want a filter listbox, if I select Half year in period listbox, it should show only June and September in Month listbox, if I select Quarter, it should show only Mar,Jun,Sep and Dec in the same Month listbox.

How can I achieve this?

Re: Data island

Gysbert_Wassenaar — Wed, 19 Aug 2015 09:57:08 GMT

I don't understand the logic at all, but you can try using the Field trigger of the Period field and assign a Select in Field action to it that makes the selections you want. Or perhaps it's easier to create bookmarks for your selections and use a Apply Bookmark action instead.

Re: Data island

jonas_rezende — Wed, 19 Aug 2015 14:15:56 GMT

Hi, Gautham Prasad.

See if the qvw attached helps.