topic Trellis chart to show multiple expression values in QlikView

Trellis chart to show multiple expression values

alex_stone — Wed, 31 May 2017 17:21:44 GMT

We can find that there is a example file on C:\Program Files (x86)\QlikView\Examples\Documents\Data Visualization.qvw -->> Trellis tab

It will show the chart on grid format. But, current it can show one expression value only.

e.g.

Can we add one more expression to show total count of clients as line style on the same chart?

Sergey_Shuklin — Wed, 31 May 2017 17:52:07 GMT

Hello, Alex!

Change the graph style to Combo Chart and you will be able to make lines and dots.

I just added one line with constant 0.2 (red line).

alex_stone — Wed, 31 May 2017 18:13:13 GMT

Thanks Sergey. How can we add expression like

Count({<Region = {GERMANY, JAPAN, NORDIC, USA}>} [Account Number]) ?

Sergey_Shuklin — Thu, 01 Jun 2017 04:37:53 GMT

If we are lookin' at specifically this example so there is a field called "Customer Number".

So the second expression (line) would be:

=Count({<Region = {GERMANY, JAPAN, NORDIC, USA}>} [Customer Number])

yes, it is the same as you wrote, but count is the absolute value enstead of "Achieved".

Next we need to do some axis manipulating, go to the Axes tab :

1. Select our second expression and set it to the second axis: Position -> Right(Top);

2. Turn off "Forced to 0" - line would be more comfortable to read;

3. Turn on "Hide axis" - it will hide absolute values, because we don't need them much (I suppose).

That all. After all this steps you'll get the line which interprets a customer count per mounth.

alex_stone — Thu, 01 Jun 2017 23:22:41 GMT

Great, it works fine. Thanks a million!

Sergey_Shuklin — Fri, 02 Jun 2017 04:16:31 GMT

Hello, Alex!

Glad to hear it! If your issue is solved you can close a topic by marking the right answer 😃 Thank you.