Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vishalmanu
New Contributor III

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
New Contributor III

Re: Need to show weekly minimum average

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

MVP
MVP

Re: Need to show weekly minimum average

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

vishalmanu
New Contributor III

Re: Need to show weekly minimum average

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.

MVP
MVP

Re: Need to show weekly minimum average

What is the expected output in terms of the numerical output

vishalmanu
New Contributor III

Re: Need to show weekly minimum average

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

MVP
MVP

Re: Need to show weekly minimum average

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
New Contributor III

Re: Need to show weekly minimum average

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