Previous Monthstart till date values for selected date in Script

[yuvraj_33]

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]

MonthStart(Date,-1) as PreviousMonthStart

hope this helps

regards

Marco

[sunny_talwar]

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]

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]

I think you might find this interesting

The As-Of Table