topic Re: Hiding one value in chart dimension in QlikView

Hiding one value in chart dimension

Thu, 22 Jan 2015 10:42:42 GMT

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

Re: Hiding one value in chart dimension

Gysbert_Wassenaar — Thu, 22 Jan 2015 10:53:29 GMT

See attached example

Re: Hiding one value in chart dimension

alexandros17 — Thu, 22 Jan 2015 10:54:04 GMT

This is a solution

Re: Hiding one value in chart dimension

Thu, 22 Jan 2015 11:19:27 GMT

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:

Re: Hiding one value in chart dimension

Gysbert_Wassenaar — Thu, 22 Jan 2015 11:22:21 GMT

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

Re: Hiding one value in chart dimension

Thu, 22 Jan 2015 11:27:28 GMT

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"?

Re: Hiding one value in chart dimension

Gysbert_Wassenaar — Thu, 22 Jan 2015 11:33:38 GMT

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

Re: Hiding one value in chart dimension

kuba_michalik — Thu, 22 Jan 2015 11:39:01 GMT

=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

Re: Hiding one value in chart dimension

Thu, 22 Jan 2015 12:01:09 GMT

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!

Re: Hiding one value in chart dimension

Thu, 22 Jan 2015 12:02:25 GMT

Thank you for explanation!

Re: Hiding one value in chart dimension

Gysbert_Wassenaar — Thu, 22 Jan 2015 12:23:16 GMT

You're right that valuelist doesn't have its own entry in the help file. It should have imo, but unfortunately it doesn't. You can find it by looking for synthetic dimension values.