topic Re: week chart in QlikView

week chart

mshailaja — Wed, 25 Nov 2020 16:16:04 GMT

i have week chart from 1 to 52

if the dashboard refresh everyday i want to show the last weeks chart and last 7 days chart. How?

Anonymous — Fri, 24 Mar 2017 08:54:11 GMT

try below:

create weeknumber field

add set analysis to your expression.

For last week something like:

{<Weeknum = ,Weeknum={"=$(=Max(Weeknum)-1)"}>}

For last 7 days something like

{<datenum= ,datenum={">=$(=Max(datenum)-7) <= $(=Max(datenum))"}>}

Hope it helps. Or else if you can share a sample qvw it would be better.

avinashelite — Fri, 24 Mar 2017 08:55:38 GMT

Use Triggers .

Document properties > Triggers > On open > Add the action > select in Field >

Field name > Expression > =Week(Today())