Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
knkirubakaran
Contributor III
Contributor III

Define the ID based on date History

Define/categorize the ID's based on date History from current month. If ID is not available means categorize new, if it's already available categorize by year.

imglo.PNG

5 Replies
Anil_Babu_Samineni

Not sure, I followed you. Can you clear little in detail

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)
knkirubakaran
Contributor III
Contributor III
Author

find thecurrent month ID's in the existing data, if not cateogrize as New ID

Anil_Babu_Samineni

Can you share excel file and expected result

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)
ben_pugh
Creator
Creator

Can't you just define current month and current year in variables, something like:

vCurrentMonth= Month(Today())

vCurrentYear= Year(Today())

and then use these in calculations with your date field to determine difference between the values in your data and current year and month,

ben_pugh
Creator
Creator

for example, you could use (vCurrentYear*12)+vCurrentMonth to create a field where the value increases by 1 each month... and then compare this to ({Year in your data]*12)+[month in your data]

so for any given month and year this would tell you the difference from current month and year