Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

MVP
MVP

Is it possible to by pass a dimension in Pivot table

Hi All,

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...

1 Solution

Accepted Solutions
Not applicable

Is it possible to by pass a dimension in Pivot table

The last expression works, with no blanks.

7 Replies
Highlighted
Not applicable

Is it possible to by pass a dimension in Pivot table

Hi,

You could try : aggr( sum(Value), Country )

llauses243
Contributor III

Is it possible to by pass a dimension in Pivot table

Hi,

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

Not applicable

Is it possible to by pass a dimension in Pivot table

Or this also works : sum(total <Country> Value)

MVP
MVP

Is it possible to by pass a dimension in Pivot table

Thanks for your reply. But it does not help.... i don't want blank....look at the attachment.

Regards,

tresesco.

Not applicable

Is it possible to by pass a dimension in Pivot table

The last expression works, with no blanks.

MVP
MVP

Is it possible to by pass a dimension in Pivot table

Thanks Xena. It worked!!

Luminary
Luminary

Is it possible to by pass a dimension in Pivot table


llauses wrote:
basic rules ... aggr sum aggr NO, sum aggr sum NO<div></div>


Hi Ilauses, what do you mean with this basic rule ?