Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.

tresesco
MVP
MVP
Author

Thanks Xena. It worked!!

pablolabbe
Luminary Alumni
Luminary Alumni


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


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