topic Re: Pie chart problem in QlikView

Pie chart problem

venkey2847 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have to create one Pie chart.

I am deriving dimension fields by using measures.

If(wrsale<10000 and (wrsale-exsale)<50000),''yes',

'no') as indicator.

If(indicator= ''yes','high','Low') as result.

Now I need to create a pie chart with the dimension.

How can I take expression.

The expression should be like above if condition.

Because I need to show the percentage.

Please help me out on this issue.

Thanks

Venkey

YoussefBelloum — Fri, 16 Mar 2018 15:10:16 GMT

Hi,

before creating the barchar, when you calculate the INDICATOR field:

If(wrsale<10000 and (wrsale-exsale)<50000),''yes',

'no') as indicator.

if wrsale is lowel than 10000, so wrsale-exsale will always be lower than 50000..

so maybe change it to this:

If(wrsale<10000 OR (wrsale-exsale)<50000),''yes',

'no') as indicator.

I'm I right ?

Digvijay_Singh — Fri, 16 Mar 2018 15:16:14 GMT

Do you have sample to share here? Not sure but may be -

Dimension-

Aggr(If(indicator= ''yes','high','Low') ,indicator)

Measure -

Count(indicator)

Not sure if it will work, sample will help to understand it better