Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
yuvraj_33
New Contributor III

Previous Monthstart till date values for selected date in Script

Dear All,

I am having a scenario where I am having a table with fields as below:

Table:

Material,

Date,

Value

I need to fetch data from previous month start date till selected date.

i.e. If date 25-12-2016 is selected, then all materials from 01-11-2016 to 25-12-2016 need to appear for the selection.

I need to achieve this in Qlikview script and not in front end.

Kindly assist on mentioned query.

Thanks in advance.

4 Replies

Re: Previous Monthstart till date values for selected date in Script

MonthStart(Date,-1) as PreviousMonthStart

hope this helps

regards

Marco

Re: Previous Monthstart till date values for selected date in Script

How will selection play a role here? Are you imagining using a variable which will be used while reloading to determine what is selected date?

yuvraj_33
New Contributor III

Re: Previous Monthstart till date values for selected date in Script

Selection is just imagining for a particular month while building script. Any which ways you have to select a month in front end to see the changes.

Requirement is, when I'll select a particular month in front end, data from previous monthstart till selected month should populate.

This could be achieved in front end, however I have a logical requirement where I have to define it in script.

Re: Previous Monthstart till date values for selected date in Script

I think you might find this interesting

The As-Of Table