Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Hiding one value in chart dimension

Hi,

Probably it's easy, but I can't figure it...

I have a bar chart with one dimension and few expressions. Let's say, that the dimension has values "A", "B" and "C".

On chart I don't want to show all values on X-axe, but only:  A, B, and also B+C and sum A+B+C .

In other words, in attached document I want to hide "C" bar on chart and add "B+C" instead.

How to do this?

Thank you in advance.

Bartek

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Hiding one value in chart dimension

There's a function called valuelist. Its use is explained in the help file. Normally the help file is installed when you install Qlikview. Press F1 to open the help file.

See also this blog post: ValueList() – For those tricky situations


talk is cheap, supply exceeds demand
10 Replies
MVP & Luminary
MVP & Luminary

Re: Hiding one value in chart dimension

See attached example


talk is cheap, supply exceeds demand

Re: Hiding one value in chart dimension

This is a solution

Not applicable

Re: Hiding one value in chart dimension

Thank you both.

Gysbert, your solution works great, but it is necessary to modify the script. My app is huge, has many sheets and the model is very complicated - I would like to avoid modifying script just for one chart. Is there some another way to get same result without changing script?

Alessandro, your solution is also ok., thanks, but I must to show at least 2 measures - and here more measures means many more additional expressions, and the presentation will be also less clear.

I need to achieve this:effect:

Screen.jpg

MVP & Luminary
MVP & Luminary

Re: Hiding one value in chart dimension

You could also try using a calculated dimension using the valuelist function. Any performance problems that causes are yours to deal with .


talk is cheap, supply exceeds demand
Not applicable

Re: Hiding one value in chart dimension

For now there are no performance problems, so it is ok.

However I tried to do it using a calculated dimension and I don't know how to do it - because there is one dimension ("Ongoing projects" on screen, or "B" in my qvw example) which I want to have more than one times on chart.

What do you mean by "valuelist function"?

MVP & Luminary
MVP & Luminary

Re: Hiding one value in chart dimension

There's a function called valuelist. Its use is explained in the help file. Normally the help file is installed when you install Qlikview. Press F1 to open the help file.

See also this blog post: ValueList() – For those tricky situations


talk is cheap, supply exceeds demand
Partner
Partner

Re: Hiding one value in chart dimension

=ValueList('A','B','B+C','Total')

It's called a synthetic dimension (as it's not based on any actual, loaded data). However, it's not connected to the real data in any way whatsoever, so you'd have to take care of it in the expression itself. Instead of just sum(Value) you get:

Pick(Match(ValueList('A','B','B+C','Total'),'A','B','B+C','Total'),

     Sum({<Category={'A'}>}Value),

     Sum({<Category={'B'}>}Value),

     Sum({<Category={'B','C'}>}Value),

     Sum({<Category={'A','B','C'}>}Value)

))

My personal opinion on that is it's a bit of an abomination

Not applicable

Re: Hiding one value in chart dimension

I tried to find "ValueList" function in the help file, but I didn't see it there, so thanks for the link to the blog post - I used it in my situation and it works perfectly.

Thank you!

Not applicable

Re: Hiding one value in chart dimension

Thank you for explanation!