topic Re: If statement to change dimension with selection in QlikView

If statement to change dimension with selection

Mon, 06 May 2013 18:52:35 GMT

I have 2 variables Region_Old and Region_New (from 2 different datasets - Old and New)- both have similar fields but for different row fields. My whole sheet uses Region_New but for one GAUGE chart i need to use Region_Old.

So when the user selects "Asia" in Region_New listbox i want it to lookup "Asia" in Region_Old and show numbers for that instead of the Asia per Region_New.

Please help?

Re: If statement to change dimension with selection

Mon, 06 May 2013 20:59:37 GMT

How similar are they?

If they're exactly the same, you might be able to get away with naming both variables 'Region', and using it as a link between the two tables. Since the row fields are different, they should have different names.

If they aren't exactly the same, you would probably have to do something fancy with AGGR() to get the two tables linking up correctly.

Re: If statement to change dimension with selection

Mon, 06 May 2013 22:48:53 GMT

No, naming them the same and linking won't work. Already have a key and usind this one won't link the tables correctly anyway.

Think of that chart as stemming only from that "Old" data sheet. This region field shouldn't impact all other charts and vice versa.

P.S. Aggr won't work. Alternate states is closer to what i need but it'd be too complex/confusing for a User who won't know crap about it.

Re: If statement to change dimension with selection

sujeetsingh — Tue, 07 May 2013 04:32:25 GMT

Hi Asakshi,

First of all you can handle this in Script too.

Now for UI level plz provide a sample !!