topic Re: calculated dimension issue in QlikView

calculated dimension issue

Anonymous — Tue, 06 Mar 2012 07:59:33 GMT

hi gurus,

i have a dimension like media, under media f1,f2,f3,f4 are the fields

revenue is the target calculation

Problem :

sum(f1,f2,f3) = revenue of r1

sum(f4) = revenue of r2

how to break the total reenue as r1 , r2 revenue

plz help me out.

thanks

kaushiknsolanki — Tue, 06 Mar 2012 08:38:55 GMT

Hi,

Put calculated dimension as

=if(wildmatch(Media,'F1','F2','F3'),'R1','R2')

Give lable as Rvenue

And add expression as Sum(Rev)

For more info have a look at the application

Anonymous — Tue, 06 Mar 2012 12:02:25 GMT

hi kaushik,

r1 and r2 are sharing the X axis when i turned to line chart

i want to dispay separately in line chart

plz help me to achieve the same

kaushiknsolanki — Tue, 06 Mar 2012 12:16:40 GMT

HI,

Do you mean you just want only points to be displayed instead of join. Something like shown in the below pic.

If yes then go to expression in Display options remove the Deselect the line and select the symbol.

Regards,

Kaushik Solanki

Anonymous — Tue, 06 Mar 2012 12:23:46 GMT

hi koushik,

Separate line for r1 revenue and r2 revenue from x axis

if i take month Also As dimension

kaushiknsolanki — Tue, 06 Mar 2012 12:37:35 GMT

Hi,

Keep month as first dimension and Revenue(Calculated Dimension) as Second dimension.

Regards,

Kaushik Solanki