Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a trend line with data that is updating regularly?

Hello,

I'm trying to create a trend line by month of data that is updating weekly. Below is the calculation used for something to be considered in "compliance". i want to use this to show what was in compliance for each week for the past month, while the other charts update using the weekly data. see picture below for my concern, the most  current week consistently is spiking.

= Count({< WRK_STATUS = {3} >} IF(LoginDate >= Date(Today()-7 , 'MM/DD/YYYY') AND LoginDate <= Date(Today(), 'MM/DD/YYYY'), WRK_STATUS))

Thanks

WS.png

2 Replies
Anil_Babu_Samineni

May be this?

=Count({$< WRK_STATUS = {3}, Month= ,Year = {'$(=Max(Year))'}, LoginDate = {">=$(=Date(Today()-7 , 'MM/DD/YYYY')) <=$(=Date(Today(), 'MM/DD/YYYY'))"} >} WRK_STATUS)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

This didn't work, but would this "freeze" the data so it retains historical data while the rest of the file keeps reloading?