topic Different dimension fields have different expressions in QlikView

Different dimension fields have different expressions

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

Dear All：

Hi,My goal is shown below：

Resources：

LOAD * INLINE [

PP, Set, Value

MM, AA, a1

MM, AA, a2

YY, AA, a3

YY, BB, b1

HH, BB, b2

HH, BB, b3

XX, CC, c1

XX, CC, c2

XX, CC, c3

];

Try the results:

Can you help me?

jyothish8807 — Mon, 06 Nov 2017 05:24:41 GMT

Try like this:

expression:

if(ColumnNo()=1,1,if(ColumnNo()=2,2,3))

Br,

Anil_Babu_Samineni — Mon, 06 Nov 2017 08:44:07 GMT

Not sure, What you are looking, If you create 3 dimensions and without measure you will reserve it,

1) Make sure, to change from column to row of second and third dimensions

2) Suppress null value in presentation tab..

Anonymous — Mon, 06 Nov 2017 09:11:15 GMT

Thank you. Your example has helped me a lot.