Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
femkescholten
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
dplr-rn
Partner - Master III
Partner - Master III

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
dplr-rn
Partner - Master III
Partner - Master III

Use TOTAL <Characteristic>

femkescholten
Contributor II
Contributor II
Author

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


dplr-rn
Partner - Master III
Partner - Master III

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

femkescholten
Contributor II
Contributor II
Author

Hello Dilip,

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

Kind regards,
Femke

dplr-rn
Partner - Master III
Partner - Master III

no problem