topic Re: Re: Dynamic Excel Selection in QlikView

Dynamic Excel Selection

Thu, 10 Jul 2014 12:26:11 GMT

Hi All

I have seven diffrent Excel files as datasource

all the seven excel files from different folders and the table structure is same.

i have values for

Round 1, round2 etc till round 7

My requirement is to add a dropdown button in each tab it should show the values based on selected round without reload

Please help me

Re: Dynamic Excel Selection

alexandros17 — Thu, 10 Jul 2014 12:28:36 GMT

When you load the excel add a field in each file to identify the excel file n.

Load

field1,

...

fieldn,

'1' as XLSNum

from .....

then in your tabs the selector will filter XLSNum, 1 will show only rows from first file ...

Re: Dynamic Excel Selection

Thu, 10 Jul 2014 12:38:36 GMT

Thanks Alessandro

I have tried this but when i select any list box item,the dropdown selection disappears and it starts showing values based on all rounds

Re: Dynamic Excel Selection

alexandros17 — Thu, 10 Jul 2014 12:46:42 GMT

send me your document....

Re: Re: Dynamic Excel Selection

Thu, 10 Jul 2014 13:54:06 GMT

PFA

i need a dropdown on everu tab to show the values based on the round selection by users

Re: Dynamic Excel Selection

Fri, 11 Jul 2014 08:00:26 GMT

any sollution pls?

Re: Re: Re: Dynamic Excel Selection

alexandros17 — Fri, 11 Jul 2014 08:14:12 GMT

You had nearly done it, I've added on each sheet a dropdown with fileflag, select it and look at the results

Re: Dynamic Excel Selection

Fri, 11 Jul 2014 08:40:04 GMT

Thanks Alessandro,

its working fine but only till am selecting some list box item.

for eg : Round1 has data only for zone : APAC and country: CHINA if I select round 1 and zone: MEX on list box its starting to show values for other rounds as well.

the requirement is like all the objects and listbox data everything based on the selected round on dropdown and it should not show other round values unless untill user select any other round on dropdown.

Thanks Again

Re: Dynamic Excel Selection

alexandros17 — Fri, 11 Jul 2014 08:44:41 GMT

But probably the behaviour is correct because of the alternate state set in some objects