topic Re: Day in QlikView

Day

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

Hi,

I want to show first seven days starting from today in the X axis of a chart.(ex 28 to 4)

Actually I have a field named 'Day' which contains data from 1 to 31.

I tried taking calculated dimension as: if(Day>=day(today()) and Day<day(today()+7),Day), but it doesn't help.

Please suggest.

sushil353 — Mon, 28 Nov 2016 08:28:11 GMT

Try this:

Sum({<Day={">=$(=Day(today())) <=$(=Day(today())+7)"}>}Sales)

Sum({<Datefield={">=$(=today()) <=$(=today()+7)"}>}Sales)

HTH

Anonymous — Mon, 28 Nov 2016 08:55:04 GMT

don't require sum of sales

MK_QSL — Mon, 28 Nov 2016 09:02:36 GMT

Use as below..

=Day(IF(YourDateField>= Today() and YourDateField< Today()+7, YourDateField))

Tick Suppress When Value is Null