Showing summarized/aggregated data in graphs

jossebb1 — Tue, 21 Aug 2018 07:58:51 GMT

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

Re: Showing summarized/aggregated data in graphs

jossebb1 — Wed, 22 Aug 2018 11:57:37 GMT

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.

topic Re: Showing summarized/aggregated data in graphs in QlikView

Showing summarized/aggregated data in graphs

Re: Showing summarized/aggregated data in graphs