topic Re: Expression after horizontally listed expression in QlikView

Expression after horizontally listed expression

Mon, 10 Jun 2013 20:10:41 GMT

How can I add an expression after a horizontally listed expression without it falling under the horizontal values? In the case below, I want to list the sum of sales for each customer# after the last Product column value.

So I DONT get this result:

Re: Expression after horizontally listed expression

swuehl — Mon, 10 Jun 2013 23:16:37 GMT

You can use partial sums (AKA subtotals / totals, which you can enable in presentation tab per dimension) and use dimensionality() resp. secondarydimensionality() to switch your one expression to show your discount percentages in your detail columns and the sum in your total column.

Something along these lines:

=if(SecondaryDimensionality() = 0,

YourSumExpression,

YourPercentageExpression

)

Re: Expression after horizontally listed expression

Tue, 11 Jun 2013 14:49:28 GMT

Excellent answer swuehl! That worked perfectly. Any suggestions on how to format the two ( sales, percent ) seperately? I currently have my expression formated as "Fixed to" 1 decimal place and "Show in Percent%" which is fine for the percentages but not the sales.

Here's my expression now:

If(SecondaryDimensionality() = 0, If(Sum([Discount Percent]) > 0, Money(Sum([Sales Amount]))), [Discount Percent])