topic Re: Define the ID based on date History in QlikView

Define the ID based on date History

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Define the ID based on date History

Anil_Babu_Samineni — Wed, 10 Jan 2018 12:57:02 GMT

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

Re: Define the ID based on date History

Anonymous — Wed, 10 Jan 2018 13:00:02 GMT

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

Re: Define the ID based on date History

Anil_Babu_Samineni — Wed, 10 Jan 2018 13:47:16 GMT

Can you share excel file and expected result

Re: Define the ID based on date History

Ben_P — Wed, 10 Jan 2018 15:12:58 GMT

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,

Re: Define the ID based on date History

Ben_P — Wed, 10 Jan 2018 15:17:28 GMT

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