topic Re: date dimension - qlik sense in App Development

date dimension - qlik sense

joeybird — Wed, 07 Mar 2018 16:20:30 GMT

using qlik sense

I have the following as a dimension

IF(Date>=Date(Today()-70),Date)

this shows latest 10 weeks activity on a chart / dashboard

however... I wish to be able to pick a date from a filter (WeekCommencing), but if the week commencing date is before the latest 10 weeks of activity, it just shows me 10 weeks of activity from the week commencing date chosen

please help

Re: date dimension - qlik sense

rubenmarin — Wed, 07 Mar 2018 16:50:12 GMT

HI Joanna, maybe with:

=IF(Date>=Date(Max(TOTAL DateField)-70),Date)

Re: date dimension - qlik sense

joeybird — Wed, 07 Mar 2018 17:07:15 GMT

This now shows only that week chosen, but is showing 10 weeks from the date

so if I chose 01/01/2018... this will give me 29/10/2017 and is showing past 01/01/2018 up to todays date

so if I chose 01/01/2018 I just want it to show me

01/01/2017 to 29/10/2017

please help