Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

User defined standards: Group TOTAL expression by pivot dimension

Hello,

I'm having some difficulties building an expression. What we need is to compare object values to a standard/control object that can be selected from a list (in an alternate state called Standards).

In the first pciture you see it works fine for 1 Charcteristic (K), in the second picture you see what happens when all Characteristict (K, N, Na) are selected. The standard is averaged over all Characteristics but I would like to have this standard grouped by characteristic too. Does anyone know how to accomplish that?


Any help would be great!!!

The expressions:

Avg                =Avg(_Value)

Std                 =Avg(TOTAL {<Object={$(vStandards)}>} _Value)

% Of Std        =(Avg(_Value)/Avg(TOTAL {<Object={$(vStandards)}>} _Value))

And variable:

vStandards    =Concat(DISTINCT {Standards} chr(39) & Object & chr(39), ',')

Standards K.pngStandards All.png

1 Solution

Accepted Solutions
Partner
Partner

check the attached qvw to check if the output is correct. if not let me know in a table format the desired output

View solution in original post

5 Replies
Partner
Partner

Use TOTAL <Characteristic>

Contributor II
Contributor II

Hello Dilip,


The answer you give doesn't work, it gives me the total average, not per Characteristic and Selectected objects, nevertheless thanks for looking into the question.


I need something like:

=(Avg(_Value)/Avg(TOTAL {<Characteristic={ ... here goes the characteristic of the pivot dimension },Object={$(vStandards)}>} _Value))


Regards,

Femke


Partner
Partner

check the attached qvw to check if the output is correct. if not let me know in a table format the desired output

View solution in original post

Contributor II
Contributor II

Hello Dilip,

Indeed, that's perfect!! Thanks so much for the help!!

Kind regards,
Femke

Partner
Partner

no problem