Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Master II
Master 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
Master II
Master 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
Contributor
Contributor

Re: Different dimension fields have different expressions

Thank you. Your example has helped me a lot.