topic Re: Classify expressions in different category in QlikView

Classify expressions in different category

dsharmaqv — Wed, 25 Nov 2020 16:16:04 GMT

Hi I have created straight table with 8-10 expressions and trying to classify under different header title(same as above).

Can some one assist me to achive above visualization

Many Thanks in Advance

Deepak

jonathandienst — Thu, 01 Dec 2016 11:24:16 GMT

First< i would load the dimensional structure in the load script To mimic your example, you need something like:

Dimension:

LOAD Dual(Detail, RowNo()) as Detail,

Header

Inline

[

Detail, Header

Expression1, Header 2

Expression2, Header 2

Expression3, Header 3

...

];

The dual makes Detail numeric which simplifies the expressions.

Now create a pivot table dimensions Detail, Header, Country .

Add an expression of the form:

Pick(Detail,

// expression 1

... ,

// expression 2

... ,

// expression 3

... ,

)

Replace the ellipses with the actual expressions you need in each column.

Now pivot the table by dragging the Detail and Header to the top of the table.

Anil_Babu_Samineni — Thu, 01 Dec 2016 11:36:13 GMT

You may elaborate more with Sample Data that offers you lot. this is my personal advice

W1) We can create Valuelist Calc Dimension and then use those Expression for specific metrics like

ValuesList('Header 3','Header 4','Header 5')

Expression would be

If(ValuesList('Header 3','Header 4','Header 5') = 'Header 3', Expression1, Expression2)

This will come like Header 3 as shown above table