Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
I have a qvd load like below. Here Month Field contains the data from Jan to Sep.
How to load only Max(Month) data dynamically instead of hard code in where condition.
Please help me on this.
Thanks in advance.
max(Month) as maxMonth
let vMaxMonth = peek( 'maxMonth',0,'MaxMonth') ;
drop table MaxMonth ;
View solution in original post
you can't like this you shoud load data with no condition
after this load the max(month) in a variable
after this you can reload data with the condition where Month = vMaxMonth
Thank you .. Its working
Using Max(Month) on Months that are stored as text will be difficult. You could possibly apply a mapping to the retrieved data if you want to work with Max(Month).
However, if you just want to retrieve the data of the current month, a simple:
Where Month = Month(Today());