Skip to main content
Announcements
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is it possible to Create an Expressions with multiple sub-expressions ?

Is it possible to create the below :

Capture.JPG

Basically under the Period Expression we have Sub Expression for Delivery Type .

Regards

TSM

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Yes, its possible. You just drag the second dimension to top of expressions.

View solution in original post

7 Replies
Not applicable
Author

Hi,

Yes, its possible by using Pivot table. You can take Customer and MonthYear as dimensions and Type A to D can be the expressions.

Not applicable
Author

Hi ,

Thanx for the quick update .

Im actually trying to find out if Qlikview allows the Pivoting to be vertical as well ?

Currently i have the Pivot Table : Year and Customer (Dimensions) and Delivery Type (Expression), as well as the way you suggested but users not happy with this.

I guess they to use to Excel .

Not applicable
Author

Hi,

Yes, its possible. You just drag the second dimension to top of expressions.

Not applicable
Author

Great That Worked .

Is there a way to limit the dimension only to only return 'Delivery type A' and 'Delivery Type C'?

Not applicable
Author

add a calculated dimension

if ("nameofyourfield" = 'Delivery Type A ' or "Nameofyourfield" =  'Delivery Type B', "NameOfYourField", null())

insert the name of your field wihtout the quotes and should work.

Not applicable
Author

Hi,

From your example, I understand that, Delivery Type A and Delivery Type C are the expressions and Customer & Year are the dimensions. But from here what you are going to limit the dimensions.

I am sorry, I could not understand you correctly. Please explain me in detail.

Not applicable
Author

Not to worry , i managed to make it work .

Basically i wanted the dimension to only return 2 of 4 values .