Discussion Board for collaboration related to QlikView App Development.
Here i have an issue of by passing a dimension in in expression (in PIVOT TABLE). For reference please find the attachment.
any input would be appreciated. Thanks...
The last expression works, with no blanks.
View solution in original post
You could try : aggr( sum(Value), Country )
basic rules ... aggr sum aggr NO, sum aggr sum NO
my offer is simil to Xena but as ... aggr( distinct sum(Value), Country )
good luck ,Luis
Or this also works : sum(total <Country> Value)
Thanks for your reply. But it does not help.... i don't want blank....look at the attachment.
Thanks Xena. It worked!!
llauses wrote:basic rules ... aggr sum aggr NO, sum aggr sum NO<div></div>
Hi Ilauses, what do you mean with this basic rule ?