topic Re: Previous week data based on field in Qlik Learning Discussions

Previous week data based on field

Thu, 29 Jan 2015 16:11:33 GMT

Hello,

I'm having trouble setting up a chart in QlikView to display data based only on the past week from a specific field. Should this be setup in the expression of the chart or in the QlikView load script? If so what is the syntax? Thank you!

Re: Previous week data based on field

its_anandrjs — Thu, 29 Jan 2015 16:50:48 GMT

Hi,

Provide some data for this will be more easy and fast.

Regards

Anand

Re: Previous week data based on field

Thu, 29 Jan 2015 16:58:45 GMT

I have this in the expression of the bar chart but I need to limit it where Official Date is within the past 7 days based on today(). How could I set this up in the expression?

Count

([Type of Change])

Re: Previous week data based on field

its_anandrjs — Thu, 29 Jan 2015 17:10:50 GMT

Hi,

In the expression you can try

Count (if( Date = Date((Today()-7),'MM/DD/YYYY'), [Type of Change]))

Regards

Anand

Re: Previous week data based on field

Thu, 29 Jan 2015 20:40:22 GMT

That worked, I just added >= too set it to a range for the past 7 days. How can I alter this expresion to be based off of specific days of the week? So for example to show the past week of data (Monday-Friday) changing to the next week on the following Friday?

Re: Previous week data based on field

its_anandrjs — Thu, 29 Jan 2015 20:49:53 GMT

Hi,

For dynamically load the past 7 days data back from current date then use this SET expression

Ex:-

Sum({< Date = {'>=$(=Date((Today()-7),'MM/DD/YYYY'))'} >} Metrics )

Regards,

Anand

Re: Previous week data based on field

its_anandrjs — Thu, 29 Jan 2015 20:59:51 GMT

Hi,

For every week from Monday to Saturday values try this expression

Ex:-

Sum({<Date = {'>=$(=WeekStart( Today())) <=$(=Date(WeekEnd( Today())-2))'} >} Sales)

For MON and SAT records and this is dynamic also

Regards

Anand

Re: Previous week data based on field

Fri, 30 Jan 2015 13:01:38 GMT

Does this expression just get placed in the chart expression? If so where does my count of [type of change] fit into the equation?

Re: Previous week data based on field

Agis-Kalogiannis — Fri, 30 Jan 2015 13:18:24 GMT

You can always use your count([type of change]) instead the sum(Sales) with the same set analysis expression Lindsay

count({<Date = {'>=$(=WeekStart( Today())) <=$(=Date(WeekEnd( Today())-2))'} >}[type of change])

count({<Date = {'>=$(=Date((Today()-7),'MM/DD/YYYY'))'} >}[type of change])