Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
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
Highlighted
Not applicable

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

Hi,

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

View solution in original post

7 Replies
Highlighted
Not applicable

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

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.

Highlighted
Not applicable

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

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 .

Highlighted
Not applicable

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

Hi,

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

View solution in original post

Highlighted
Not applicable

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

Great That Worked .

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

Highlighted
Not applicable

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

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.

Highlighted
Not applicable

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

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.

Highlighted
Not applicable

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

Not to worry , i managed to make it work .

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