Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
tresesco
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

The last expression works, with no blanks.

View solution in original post

7 Replies
Not applicable

Hi,

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

llauses243
Creator III
Creator III

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

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

tresesco
MVP
MVP
Author

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

Regards,

tresesco.

Not applicable

The last expression works, with no blanks.

View solution in original post

tresesco
MVP
MVP
Author

Thanks Xena. It worked!!

pablolabbe
Luminary
Luminary


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


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