Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lawrancehere
Contributor
Contributor

Qlikview - Expression based on Dimension

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 DateReport monthReport Week Report QuarterReport YearOrder TypePPF PPNO
11/09/2020Nov-20WK-45Q32020Back OrderAAA
11/09/2020Nov-20WK-45Q32020Back OrderBBB
11/09/2020Nov-20WK-45Q32020ReleasedAAA
11/08/2020Nov-20WK-45Q32020Back OrderAAA
11/08/2020Nov-20WK-45Q32020ReleasedBBB
11/08/2020Nov-20WK-45Q32020Back OrderAAA
11/08/2020Nov-20WK-45Q32020ReleasedCCC
10/07/2020Nov-20WK-42Q32020Back OrderDDD
10/07/2020Nov-20WK-42Q32020ReleasedAAA
10/07/2020Nov-20WK-42Q32020Back OrderAAA
10/07/2020Nov-20WK-42Q32020ReleasedDDD

 

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:

 

Capture.JPG

 

Labels (3)
2 Replies
Martijn_W
Contributor III
Contributor III

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

 

lawrancehere
Contributor
Contributor
Author

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.