topic Re: How to display the sates data based on the zone wise in QlikView

How to display the sates data based on the zone wise

ravindraa — Thu, 25 Sep 2014 07:56:40 GMT

Hi all,

I have one requierment that i have to display the data based on the state wise after select the zone.

i have Zone field and state field like below

Zone State

Zone1 UP

Zone1 Bihar

Zone1 Orisa

Zone2 Tamilnadu

Zone2 Andhra

Zone2 Karnataka

Zone3 Gujarat

Zone3 Rajastan

Zone3 MP

I have crated the pie charts for all Zone's ,zone1 ,Zone2,zone3 ,if i select Zone1 chart it has to display the all corsponding states charts and like if i select the Zone2

it has to display the all corsponding state charts like for zone3 also ,it has to display dynmicaly in one sheet only .

please find the attachments.

please give me any suggesion on this.

thanks in advance........

Re: How to display the sates data based on the zone wise

sundarakumar — Thu, 25 Sep 2014 08:18:42 GMT

Hi Ravindraa,

PFA the application where it has been implemented

The formula specified by textbox 1 will return the first state under the zone.. this is done with subfield function

u can cahnge the unmber to get the second and third values as specified in textbox2 and textbox 3.

Then u can use this to create a calculated dimension to show values only for that state as done in the bar chart..

Use conditonal layout to hid these if no zone is selected.

the main problem is we cannot be sure that each zone will ahve the same number of states, hence if a zone gets added with four states this is not good solution.

So i have added another sheet with a trellis chart.. this may fulfill ur requriement...

Hope this helps..

-Sundar

Re: How to display the sates data based on the zone wise

ravindraa — Thu, 25 Sep 2014 12:29:30 GMT

Hi Kalaimani sundarakumar,

Thak you very much for your help i t is working fine .

Again thank you very much.

Re: How to display the sates data based on the zone wise

sundarakumar — Thu, 25 Sep 2014 12:53:51 GMT

You are welcome