topic Re: Qlikview - Expression based on Dimension in QlikView

Qlikview - Expression based on Dimension

lawrancehere — Fri, 15 Nov 2024 23:39:53 GMT

All ,

I am beginner in Qlikview , i have below queries in chart object can some body help me with below issue that would be great !

Below is my data set and requirements :

Report Date	Report month	Report Week	Report Quarter	Report Year	Order Type	PPF PPNO
11/09/2020	Nov-20	WK-45	Q3	2020	Back Order	AAA
11/09/2020	Nov-20	WK-45	Q3	2020	Back Order	BBB
11/09/2020	Nov-20	WK-45	Q3	2020	Released	AAA
11/08/2020	Nov-20	WK-45	Q3	2020	Back Order	AAA
11/08/2020	Nov-20	WK-45	Q3	2020	Released	BBB
11/08/2020	Nov-20	WK-45	Q3	2020	Back Order	AAA
11/08/2020	Nov-20	WK-45	Q3	2020	Released	CCC
10/07/2020	Nov-20	WK-42	Q3	2020	Back Order	DDD
10/07/2020	Nov-20	WK-42	Q3	2020	Released	AAA
10/07/2020	Nov-20	WK-42	Q3	2020	Back Order	AAA
10/07/2020	Nov-20	WK-42	Q3	2020	Released	DDD

Requirement :

I need to create Line chart to see trend on count of PPF_PPNO column based on dimension like

If user selects Week - Last day of the week what was the count it should show in graph like ( if Friday count of lines is 100 means it should show 100 for that week )

If user selects Month - Average count of lines should be shown in graph like ( if i have 20 days data it should take average of it and chart should be display the value)

If user selects Quarter - Same as above

If User Selects Year - same as above

My current chart layout is as below:

Re: Qlikview - Expression based on Dimension

Martijn_W — Mon, 09 Nov 2020 17:00:15 GMT

Hi Lawrance,

Can you please elaborate on the requirement?

It would help if you could tell us in greater detail what this data represents and what those lines should be.

Example:

For a sales company I'm trying to create a chart that can alternate between:

- the count of open orders measured on the last day of the week

- the average of open order per month/quarter/year, evaluated by day.

As far as I can tell for now, you're probably going to be needing the AGGR() function for the running averages if that's what you mean. For the amount of open order (or total amount or orders for that matter, you can evaluate the date using the weekday() function in the script with a set expression in the chart expression.

Martijn

Re: Qlikview - Expression based on Dimension

lawrancehere — Tue, 10 Nov 2020 01:42:51 GMT

Hi Martijn,

Your example is my requirement you said it well. I need average open order for month, quarter and year. When it comes to week last working day of week (I made flag to count this in my input). I want count of my open order based on my selection. I am stuck on how to write expression to get average count for each selection and count of last day in the week. Can you help with building expression please.