# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner

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

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

Tags (3)
1 Solution

Accepted Solutions
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
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

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

)

Partner

## 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.

Highlighted
Partner

## 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.

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
Partner

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

That works great thanks!
{"extraction_info": {"found_math": false, "script_math_tex": 0, "script_math_asciimath": 0, "math_annotations": 0, "math_alttext": 0, "mathml": 0, "mathjax_tag": 0, "mathjax_inline_tex": 0, "mathjax_display_tex": 0, "mathjax_asciimath": 0, "img_math": 0, "codecogs_latex": 0, "wp_latex": 0, "mimetex.cgi": 0, "/images/math/codecogs": 0, "mathtex.cgi": 0, "katex": 0, "math-container": 0, "wp-katex-eq": 0, "align": 0, "equation": 0, "x-ck12": 0, "texerror": 0, "math_score": 0.8715021014213562, "perplexity": 2764.9385056284514}, "config": {"markdown_headings": true, "markdown_code": true, "boilerplate_config": {"ratio_threshold": 0.3, "absolute_threshold": 10, "end_threshold": 15, "enable": true}, "remove_buttons": true, "remove_image_figures": true, "remove_link_clusters": true, "table_config": {"min_rows": 2, "min_cols": 3, "format": "plain"}, "remove_chinese": true, "remove_edit_buttons": true, "extract_latex": true}, "warc_path": "s3://commoncrawl/crawl-data/CC-MAIN-2019-26/segments/1560627998943.53/warc/CC-MAIN-20190619083757-20190619105757-00362.warc.gz"}