Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
first of all apologies for the generic title. I'm really not sure how to describe my question in just a few words, which might be why I can't find the answer on here/google. If the question has already been answered, please feel free to point me into the right direction.
I'm quite new to qlikview, and as this is the first time im trying to display a process that has a lot of new data entries per day. To ensure the dashboard doesnt get unneccesarily slow and the qvd not unncessarily big, I decided to summarize the data in the load script using counts, sums etc.
so instead of having data in Qlik that looks like this:
Date | Type | STP | PROC |
01.01.2018 | 1 | Y | AAA |
01.01.2018 | 2 | Y | AAA |
01.01.2018 | 2 | Y | AAA |
01.01.2018 | 2 | N | AAA |
01.01.2018 | 1 | N | AAA |
It now looks like this:
Date | Type1 | Type2 | Type_Total | STP_Type1 | STP_Type2 | PROC |
01.01.2018 | 2 | 3 | 5 | 1 | 2 | AAA |
02.01.2018 | 5 | 2 | 7 | 4 | 2 | AAA |
ow I would like to create a combo chart, consisting of two bars (type 1 and type 2) and a line (displaying a STP-Percentage per type).
By creating a graph and using dimension 'AAA' and two expressions 'Sum(Type1)' and 'Sum(Type2)' I manage to show those two as bars in the graph. However, I have no idea how to display the STP-Line, so I expect this first part is not right either.
How do I do this?
Thanks in advance
Got one step further:
you can do this by creating a calculated dimension, using the ValueList() function.
However I now ran into a new issue: does anyone know where and how I can change the legend from a calculated dimension? It now shows the database column names.