Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
elena888
Valued Contributor

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
Valued Contributor

Re: Comparison between two years

Hi Elena,

Could you explain a little bit your request?

Regards

Miguel del Valle

elena888
Valued Contributor

Re: Comparison between two years

It's in the file attached..

arvind_patil
Valued Contributor III

Re: Comparison between two years

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

elena888
Valued Contributor

Re: Comparison between two years

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
Contributor

Re: Comparison between two years

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

elena888
Valued Contributor

Re: Comparison between two years

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.

Re: Comparison between two years

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?

elena888
Valued Contributor

Re: Comparison between two years

I need an expression for a text object.

Users can select just a year

sonysree88
Contributor

Re: Comparison between two years

Then you can use the alternative states to achieve this