topic Show total and 2 conditional values in chart in QlikView

Show total and 2 conditional values in chart

Fri, 12 Jun 2015 07:29:33 GMT

Hi i have a below mentioned data

name	sales 2014	sales 2015	growth
A	100	200	100
B	200	300	50
C	300	400	33
D	400	500	25

Now i want to show a chart

1) growth of company with name B

2) growth of company with highest sales in 2015 or rank one in sales 2015 i.e,D

3 total growth

thanks in advance

sanjay

Re: Show total and 2 conditional values in chart

sasikanth — Fri, 12 Jun 2015 08:03:42 GMT

Use three Expressions

1) SUM(if(NAME='B',Growth))

2)sum(if(aggr(rank(sum(Growth))=1,NAME),Growth))

3)Total Growth

Re: Show total and 2 conditional values in chart

buzzy996 — Fri, 12 Jun 2015 08:55:53 GMT

pfa,

Re: Show total and 2 conditional values in chart

Fri, 12 Jun 2015 09:13:19 GMT

Hi Shiva,

The issue is I cannot see the names of companies.... since there is no dimension in it

I have achieved the same earlier...what you have done

however i want the names also ... so that i can show what the selected company's growth is and who is its best competitor(& its growth) and the market growth is.

Re: Show total and 2 conditional values in chart

buzzy996 — Fri, 12 Jun 2015 09:44:43 GMT

u like tis?

Re: Show total and 2 conditional values in chart

Fri, 12 Jun 2015 10:51:55 GMT

Hi Shiva

For expression A, I dont want max of growth

I want the growth of company whose sales is max in 2015 ie, A

your expression is simply max(growth)

Re: Show total and 2 conditional values in chart

Fri, 12 Jun 2015 10:55:55 GMT

sorry i mentioned it as A earlier how ever its D