topic Re: Help me in below scenario? in QlikView

Help me in below scenario?

durgabhavani — Mon, 29 Jun 2015 18:08:30 GMT

Hi All,

I have three dimensions for my bar chart, say (Region, Country, State) and only one expression for calculating population.

When i click on my stacked bar chart of region, it cyclic drill downs to country level, When i click on country of chart it drills down to state level.

Now my scenario is to drill down to show different states in state level of bar chart, thereafter when i click on particular state (bar) in country it should pop up the straight table with population details.

Please help me in writing the trigger or in some other way?

Note: I implemented every thing on straight table but i am unable to pop up the straight table when i click on the particular state bar in chart.

Note: I don't want to display the particular state level bar and straight table at a time. My requirement is to pop up the straight table when i am clicking on the bar particular state bar.

Please Advice!

Thanks,

Durga

Re: Help me in below scenario?

Anonymous — Mon, 29 Jun 2015 18:14:39 GMT

Hi,

can you post sample data?

Regards.

Re: Help me in below scenario?

durgabhavani — Mon, 29 Jun 2015 18:22:35 GMT

Actually i am converting my real time scenario as above. I don't need to share details of my client.

Please see below, may be useful.

Region	Country	State	Population
Asia	India	ABC	2000
Asia	Pakistan	XYZ	3000
Asia	Srilanka	lmn	4000
Europe	Austria	pqr	2500
Europe	Belgium	sed	1500
Europe	Germany	ral	6000
SouthAmerica	Brazil	kap	5000
SouthAmerica	Chile	nam	2000
SouthAmerica	Columbia	rad	6000

Thanks,

Durga

Re: Help me in below scenario?

Anonymous — Mon, 29 Jun 2015 18:26:57 GMT

Use the GetPossibleCount() function on your State Field and use that to Conditionally show / hide your Bar Chart / Straight Table objects if they are > 1 or not. [See Layout tab of your objects]

Re: Help me in below scenario?

durgabhavani — Mon, 29 Jun 2015 18:37:25 GMT

Thanks for reply Markham, Can you please give me one example. It is very helpful to me.

Re: Help me in below scenario?

Anonymous — Mon, 29 Jun 2015 18:41:15 GMT

Could you knock up a sample qvw with the sample data you posted, get as far as you can and then share that qvw ?

Re: Help me in below scenario?

durgabhavani — Mon, 29 Jun 2015 18:53:59 GMT

I developed sample replica of my real time scenario. Can you please check once. May be it is helpful.

Re: Help me in below scenario?

maxgro — Mon, 29 Jun 2015 19:09:09 GMT

PFA

Re: Help me in below scenario?

Anonymous — Mon, 29 Jun 2015 19:15:00 GMT

Massimo's qvw sorts your requirement.

Maybe on the Straight Table change the Dimension to Drill-Down Group so it gets a Drill Up arrow displayed.