topic Re: Monthly in QlikView

Monthly

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

Hi all,

I have data in my dashboard with fiscal year 2016 and 2017

so I want to restrict the data to load >=01-01-2018

I don't have month field only fiscal year in the data.

how to get this?

Re: Monthly

YoussefBelloum — Thu, 19 Apr 2018 11:57:08 GMT

Hi,

do you want to do it on the script or on a specific chart ?

if you want to do it on the script, what is the exact format of your date field ? is it DD-MM-YYYY ? or MM-DD-YYYY ?

Re: Monthly

shiveshsingh — Thu, 19 Apr 2018 11:57:49 GMT

So you want to restrict data with condition >=01-01-2018. Do you have data for 2018 in the table? and if you have Date field?

Re: Monthly

vishalarote — Thu, 19 Apr 2018 12:07:13 GMT

use YearStart() Function

Date>=YearStart(today())

e.g

load

Date(MakeDate(2016)+RecNo()-1,'DD/MM/YYYY') as Date,

rand()*1000 as Sales

AutoGenerate 365;

Concatenate

load

Date(MakeDate(2017)+RecNo()-1,'DD/MM/YYYY') as Date,

rand()*1000 as Sales

AutoGenerate 365;

load

Date(MakeDate(2018)+RecNo()-1,'DD/MM/YYYY') as Date,

rand()*1000 as Sales

AutoGenerate 365;

STORE X into 'C:\Project\MyTable6.qvd'(qvd);

DROP Table X;

load *

From 'C:\Project\MyTable6.qvd'(qvd)

where Date>=YearStart(Today());

Re: Monthly

soniasweety — Thu, 19 Apr 2018 12:10:56 GMT

I don't have date field

I have month field and fiscal year field

Re: Monthly

vishalarote — Thu, 19 Apr 2018 12:17:10 GMT

If u have only Month and Year Field then use

=Yearstart(MonthName(Today()))

Re: Monthly

soniasweety — Thu, 19 Apr 2018 16:04:18 GMT

thanks for the response its worked but

one small doubt- Date>=YearStart(today()) this will give me what ever the data and how many months data available starting from jan 1st 2018 am I right?

Re: Monthly

vishalarote — Thu, 19 Apr 2018 17:26:40 GMT

Yes it will give u all 12 month data up to your maxdate