Discussion Board for collaboration on QlikView Scripting.
I am having a scenario where I am having a table with fields as below:
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.
MonthStart(Date,-1) as PreviousMonthStart
hope this helps
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?
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.
I think you might find this interesting
The As-Of Table