topic Re: Help me in writing expression for barchart? in QlikView

Help me in writing expression for barchart?

durgabhavani — Mon, 13 Apr 2015 04:31:27 GMT

Hi All,

I have scenario like below

I have one dimension country
it has number of states if i click on one country it should number of states based on revenueid

My dimension:
country
india
us
united kingdom
hong kong
china
ireland
srilanka

Expression need to contain below two fields:

States
26
24
15
23
10
7
11

Revenue id
1228
1234
2345
4567
6789
1345
8923
9089
999
12

Now i want to display the results on barchart when i click on country it should show the number of states where revenue id is equal to 6789?

Please advice.

Thanks,
Durga

durgabhavani — Mon, 13 Apr 2015 05:17:06 GMT

Please note that my revenueid is from other table.

Mon, 13 Apr 2015 06:02:29 GMT

Hi..

Take three dimension chart expressions .

sum(state)

count(country)

sum([revenue id]=6789)

try once ..

Thanks ,

Sreenu

amit_saini — Mon, 13 Apr 2015 06:17:15 GMT

Hi Durga,

Like this????

Thanks,

durgabhavani — Mon, 13 Apr 2015 07:52:30 GMT

Hi Sai,

Can you please share screenshots. I have no access to open the .qvw file.

Thanks,

Durga