topic Re: Displaying companies with Variants greater than A in Bar chart in QlikView

Displaying companies with Variants greater than A in Bar chart

Tue, 08 Apr 2014 18:23:35 GMT

Hi Everyone,

There are 2 dimensions company code,Variant code and 1 measure- score.I want to display the companies whose variants greater than Company A in a Bar chart(Grouped).Please find the attached Raw Excel file and the the output should be like the attached QVW.

Kindly help me in arriving at this logic.

Thanks & regards,

Hari

Re: Displaying companies with Variants greater than A in Bar chart

its_anandrjs — Tue, 08 Apr 2014 18:32:56 GMT

As i understand for your query take a Bar chart and

Dimension :- Variant Code , Company Code

and

Expression :- =Sum(Score)

Re: Displaying companies with Variants greater than A in Bar chart

jerem1234 — Tue, 08 Apr 2014 19:54:59 GMT

Please find attached. I used this formula:

if(sum(Score) >= sum({<[Company Code] = {'A'}>}total <[Variant Code]> Score) and firstsortedvalue(total <[Variant Code]>[Company Code], -aggr(sum(Score), [Variant Code], [Company Code])) <>'A', sum(Score))

Hope this helps!