Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik__Vinodh
Partner - Creator II
Partner - Creator II

help me.variable creation

HI all,

how to create financialyear previous year maxmonth ?

and

how to fix the value in expression (this value does not change while selections).

i have financialmonth,financialyear,year,month,date fields.

help me out yar............please

4 Replies
Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

help me some one.............

jagan
Luminary Alumni
Luminary Alumni

Hi,

Can you come up with Example and sample data file, it helps in understanding your requirement.

Regards,

Jagan.

Qlik__Vinodh
Partner - Creator II
Partner - Creator II
Author

hi Jagan,

tell me your phone number yar.i am from chittoor.

khadeer
Specialist
Specialist

Hi,

for suppose if ur year field is in financial year

Max(Year) is ur max year,

Max(Year)-1 is ur previous year

So for month filed

Max(Month) .....

If u can provide ur sample data i can do as relative to ur data.