Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
vishalmanu
Creator
Creator

Need to show weekly minimum average

Hi,

Please find the attached excel data file. for my client the week starts from Tuesday and ends on Monday. I have to show last weeks minimum avg 'TpT Act based on summation'  by the mould number. How can i derive the weeks based the data available. I am a bit confused. Please help me with the script or the application.

Thanks

Vishnu T

7 Replies
vishalmanu
Creator
Creator
Author

Also attaching the application that i have tried to create, but was not able to get weekly minimum average. Kindly help !

sunny_talwar

Which chart are we working with and what is the output you expect to see (numbers you think should show up)?

vishalmanu
Creator
Creator
Author

Hi Sunny,

I need to show the values in the straight table. I need to show the last weeks Mould no. Process wise which took lease minimum avg time.

sunny_talwar

What is the expected output in terms of the numerical output

vishalmanu
Creator
Creator
Author

Hi Sunny,

I need to show The Mould No which took Min avg time to produce blades process wise (Only for the last week).

Please find the below screen shot (For entire year) for the reference of Output.

Min avg.PNG

sunny_talwar

Just looking at the AM Placement process, how do you know that Mould No 132 is the latest week's value? Why not 133? I am not sure I still understand what you are looking and how do you drive it

vishalmanu
Creator
Creator
Author

Hi Sunny,

I have considered process and Mould No as dimensions and I have derived min avg time by using 'min(Aggr(Avg([TpT Act based on summation]),Process,[Mould No]))'. and i have applied dimensions limits to Mould No to show the Smallest using the same expression in the dimension limits ('min(Aggr(Avg([TpT Act based on summation]),Process,[Mould No]))'). That is how i got the below output. Now i want to show the Last weeks Min average time process wise.

Min avg.PNG