Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
43918084
Creator II
Creator II
‎2020-05-10 02:42 AM

create New dimension in Pivot table

 

 

I have created below pivot table in Qliksense. I want to create an additional field 'Status' to determine whether the Global Trade Num is early terminated.

 The formula I would use in excel is :   if("maturity date(P0288)" > "20200331" and "Ytd thismth" =0, "early terminated", "exist")

May I know how I build similar logic using set analysis?

qliksense pivot.JPG

554 Views
0 Likes
1 Reply
ToniKautto
Employee
Employee
‎2020-05-10 09:10 PM

You can not apply set expressions in dimensions, as they only exist in aggregation functions which are defined in measures. 

A set expression alters the selection state over which a expression is aggregated. It does not provide the option to apply a conditional value as you have describe in your IF statement.

I'd expect that you can accomplish the desired result by creating a measure with the IF logic. Does this not work?

522 Views
0 Likes