Creating an expression that some rows use the select list box but other rows use the whole dataset

scjma — Sat, 16 Nov 2024 21:11:29 GMT

I need to create an expression on a pivot table that will calculate some rows based on the users selection but other rows in the same position on the pivot are not to change depending on the NlAccountReportCategoryTypeID=5. This is the expression I am trying to use.

Any help would be grateful.

if(NLAccountReportCategoryTypeID=5,sum([ActualValue*-1]),sum({1<YearEnddate={$(=max(YearEnddate))}>}[ActualValue*-1]))

Re: Creating an expression that some rows use the select list box but other rows use the whole datas

chrismarlow — Fri, 22 Mar 2019 20:47:29 GMT

Hi,

You should be able to use union operator on the sets (I had to reformat the max date as well);

Cheers,

Chris.

topic Re: Creating an expression that some rows use the select list box but other rows use the whole datas in QlikView

Creating an expression that some rows use the select list box but other rows use the whole dataset

Re: Creating an expression that some rows use the select list box but other rows use the whole datas