Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaytrip
Creator
Creator

showing Previous month available in qlikview

Hi guys ,

Im facing an issue where I have Date in the qvd from 1/1/2017 to 3/1/2018 in the format MM/DD/YYYY.

but in qlikview I need to show Data only till Feb , 2018 that is (2/1/2018).

from 1/1/2017 to 2/1/2018

So thats basically excluding the previous month data i need to represent it considering that im in the month of April now.

What ways is this possible for me to go ahead with ?

Thanks

1 Solution

Accepted Solutions
abhaytrip
Creator
Creator
Author

Thanks all , this worked !

where dateField<=date(MonthStart(Today(),-2))

View solution in original post

4 Replies
shiveshsingh
Master
Master

What about applying filter while loading data from qvd?

load * from AVC.qvd(qvd) where Date <='2/1/2018'..make sure format matches

Anil_Babu_Samineni

Perhaps this?

Table:

Load * From Table;

Left Join(Table)

Load Min(DateField) as MinDate,

Max(DateField) as MaxDate

Resident Table;

LET Vmin = Peek('MinDate');

LET Vmax = Peek('MaxDate');

Final:

Load * Resident Table Where Date#(DateField, 'YourFormat') >= Date($(Vmin), 'YourFormat') and Date#(DateField, 'YourFormat') < AddMonths(Date($(Vmax), 'YourFormat', -1)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
andrei_delta
Partner - Creator III
Partner - Creator III

hi,

if you want a load without problems regarding the date you should use a numeric date and then remake your date as you desire. ( num(Date)  -> the date to numeric format )

hope it helps,

Andrew

abhaytrip
Creator
Creator
Author

Thanks all , this worked !

where dateField<=date(MonthStart(Today(),-2))