Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
joseph_eftamand
Contributor

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

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

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

)

6 Replies
jyothish8807
Honored Contributor II

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

Hi Joseph,

can you share a sample data ?

Br,

KC

Best Regards,
KC
MVP
MVP

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

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
Contributor

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

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
Contributor

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

Thanks, I willgive it a try.

jyothish8807
Honored Contributor II

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

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

Br,

KC

Best Regards,
KC
joseph_eftamand
Contributor

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

That works great thanks!