Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
New Contributor

Different dimension fields have different expressions

Dear All:

   Hi,My goal is shown below:

bb.png

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:

cc.png

Can you help me?

1 Solution

Accepted Solutions
Highlighted
Honored Contributor II

Re: Different dimension fields have different expressions

Try like this:

expression:

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

Br,

KC

Best Regards,
KC

View solution in original post

3 Replies
Highlighted
Honored Contributor II

Re: Different dimension fields have different expressions

Try like this:

expression:

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

Br,

KC

Best Regards,
KC

View solution in original post

Highlighted

Re: Different dimension fields have different expressions

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..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
New Contributor

Re: Different dimension fields have different expressions

Thank you. Your example has helped me a lot.