Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
joseph_eftamand
Partner - Creator
Partner - Creator

Is it possible to group dimensions by an expression rather than expressions by a dimension in a bar chart?

Tempd.png

In the image above GT1 GTT2 etc are the dimensions and Rel, Name, Add, Pin, Overall are the names of the expresisons used.

Is this possible in Qlik Sense?

Thanks,

Joseph

1 Solution

Accepted Solutions
swuehl
MVP
MVP

You should be able to use synthetic dimensions using Valuelist().

Something like this as first dimension

=Valuelist('Rel','Name')

Second dimension your GTs.

Then one expression branching into the relevant execution pass:

=Pick(Match(Valuelist('Rel','Name'),'Rel','Name')),

Sum(Rel), //replace with Rel code

Count(Name) // replace with Name code

)

View solution in original post

6 Replies
jyothish8807
Master II
Master II

Hi Joseph,

can you share a sample data ?

Br,

KC

Best Regards,
KC
swuehl
MVP
MVP

You should be able to use synthetic dimensions using Valuelist().

Something like this as first dimension

=Valuelist('Rel','Name')

Second dimension your GTs.

Then one expression branching into the relevant execution pass:

=Pick(Match(Valuelist('Rel','Name'),'Rel','Name')),

Sum(Rel), //replace with Rel code

Count(Name) // replace with Name code

)

joseph_eftamand
Partner - Creator
Partner - Creator
Author

I can’t unfortunately, but the requirement should be the same with any data set and expressions. I need to show the expressions on the x-axis and the dimensions in the legend.

joseph_eftamand
Partner - Creator
Partner - Creator
Author

Thanks, I willgive it a try.

jyothish8807
Master II
Master II

here is a sample attached, used the same logic suggested by stefan

Br,

KC

Best Regards,
KC
joseph_eftamand
Partner - Creator
Partner - Creator
Author

That works great thanks!