Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable
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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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