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

Previous Monthstart till date values for selected date in Script

yuvraj_33 — Tue, 03 Jan 2017 16:55:14 GMT

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.

MarcoWedel — Thu, 05 Jan 2017 00:28:20 GMT

MonthStart(Date,-1) as PreviousMonthStart

hope this helps

regards

Marco

sunny_talwar — Thu, 05 Jan 2017 02:09:26 GMT

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 — Thu, 05 Jan 2017 02:27:36 GMT

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.

sunny_talwar — Thu, 05 Jan 2017 02:29:40 GMT

I think you might find this interesting