New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Displaying companies with Variants greater than A in Bar chart

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

Tags (10)
1 Solution

Accepted Solutions
Valued Contributor II

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

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!

2 Replies
MVP

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

As i understand for your query take a Bar chart and

Dimension :- Variant Code , Company Code

and

Expression :- =Sum(Score)

Valued Contributor II

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

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!