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

Comparison between two years

Hello,

I attach a file with sample data for a case of comparison between years.

I specified data and the request.

Thanks for any help!

11 Replies
migueldelval
Specialist
Specialist

Hi Elena,

Could you explain a little bit your request?

Regards

Miguel del Valle

Anonymous
Not applicable
Author

It's in the file attached..

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Elena,

Please refer below thread:

YTQ, QTD, MTD and WTD

Re: YTD/YTD LY, QTD/QTD LY, MTD/MTD LY calculations

Thanks

Arvind Patil

Anonymous
Not applicable
Author

Thanks but they aren't the same cases...

It's not a simple comparison between periods, there is a complication due to a check on another field.

Thanks!

sonysree88
Creator II
Creator II

Can you please elaborate what exactly you are looking for..

give me some sample QVW or image which you want to do it.

regards,

Sonysree

Anonymous
Not applicable
Author

I have these data:

 

USERYEARCODE
XX2013CAP
XX2014FR
YY2014FR
ZZ2014FR
KK2014WEB

I want to count new entries in 2014 with CODE "FR".

The result in this case is 2 i.e. YY and ZZ, because they are not in 2013 and they have code "FR".

KK is excluded beacuse its code is "WEB"

XX is excluded because is already in 2013.

Miguel_Angel_Baeyens

Where's the year to start with? What should you be comparing actually, meaning, which field? How is that check on another field, which field must be compared to which? In the script or UI?

Anonymous
Not applicable
Author

I need an expression for a text object.

Users can select just a year

sonysree88
Creator II
Creator II

Then you can use the alternative states to achieve this