topic Re: create New dimension in Pivot table in App Development

create New dimension in Pivot table

43918084 — Sun, 10 May 2020 06:42:54 GMT

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?

Re: create New dimension in Pivot table

ToniKautto — Mon, 11 May 2020 01:10:56 GMT

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?