Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
venkey2847
Contributor II
Contributor II

Pie chart problem

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

2 Replies
YoussefBelloum
Champion
Champion

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

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