Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
The below note is taken from qlik developer ebook, As per the below instruction, how do i create Max (period) expression in qlikview
A simple Max(Period) expression will help us get the base period in all scenarios,
as the Period field contains both the Month and Year components. Therefore, the set
modifiers that we would use to get the record set corresponding to the base period in
each of the required comparisons are:
• Current Year-To-Date indicators:
<Period = {"<=$(=Max(Period))"}, Year = {"$(=Max(Year))"}, Quarter= , Month = >
This set modifier will result in a record set containing all of the periods that
are less than or equal to the current period, and belong to the current year,
which would be all Year-To-Date records.
There are many discussions, documents and applications you will find in this community.
QlikView App: Year To Date Using Set Analysis
YTD,QTD MTD Tables with Sum(Sales)
Calculating Year To Date Accumulation Expression
And many more.
Still if you are stuck, you may share your sample data here
Best Regards,
Kalpesh
Sorry, i cant understand the question...
hi
the below query does not work in qlikview .the below set analysis is correct ?
<Period = {"<=$(=Max(Period))"}, Year = {"$(=Max(Year))"}, Quarter= , Month = >
Hi,
Are you getting some expression error or unexpected result ?
The modifier looks okay.
This set modifier will result in a record set containing all of the periods that
are less than or equal to the current period, and belong to the current year,
The expression would take all periods less than or equal to selected period. Not exactly Current Period.
In case of year, it will take maximum year out of the current selection of year.
Hope this help !
Regards,
Kalpesh
Hi All
I would like develop a bar chart as shown below, appreciate, if anyone help me to identify what needs to be done (including creation of variables)
BR
Jayanthan
There are many discussions, documents and applications you will find in this community.
QlikView App: Year To Date Using Set Analysis
YTD,QTD MTD Tables with Sum(Sales)
Calculating Year To Date Accumulation Expression
And many more.
Still if you are stuck, you may share your sample data here
Best Regards,
Kalpesh