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

[joseph_eftamand]

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

[jyothish8807]

Hi Joseph,

can you share a sample data ?

Br,

KC

[swuehl · Accepted solution]

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]

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]

Thanks, I willgive it a try.

[jyothish8807]

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

Br,

KC

[joseph_eftamand]

That works great thanks!