Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
alex-wb
Contributor III
Contributor III

Plotting a calculation on a graph but limiting the calculation to the relevant week

Hi all,

I have the below calculation that works fine for me. However I need to plot this on a graph that is broken down into 52 weeks. How do I apply this calculation to run for each individual week since each week has a different amount of faults raised and also size of network.

count({ $<
G_DATE ={">=$(vFY_Year_Start)<$(vFY_Week_Start)"
}
>}FAULT_REF)

/

(sum({ $<
G_DATE ={">=$(vFY_Year_Start)<$(vFY_Week_Start)"}
>}PRODUCT_VOLUME)/
count(distinct{ $<
G_DATE ={">=$(vFY_Year_Start)<$(vFY_Week_Start)"}
>}G_DATE) /1000)

1 Solution

Accepted Solutions
Dalton_Ruer
Employee
Employee

I would add a Week# field in your load script so that you can can use as a Dimension or Year-Week# or however you may need it for your rolling 52 weeks or just YTD. 

That way you make the load script do the CPU work 1 time and your User Interface can fly. 

View solution in original post

1 Reply
Dalton_Ruer
Employee
Employee

I would add a Week# field in your load script so that you can can use as a Dimension or Year-Week# or however you may need it for your rolling 52 weeks or just YTD. 

That way you make the load script do the CPU work 1 time and your User Interface can fly. 

View solution in original post