Automated count

[dseelam]

Hello Qlik Folks,

How can I auto count Id's for only last year, last quarter and last half year in straight or pivot tables using if condition or set analysis

[dseelam]

Hey Marco to some extent you are right but the id life numbers are wrong

I need sum of ID life 

[dseelam]

Hello Stefan the expression is the main one all it matters

Thanks

[MarcoWedel]

Hi,

maybe like this?:

hope this helps

regards

Marco

[dseelam]

Hello Macro the sum of ID Life (EXPRESSION)still does not match if you check ID 111111

APPRECIATE YOUR HELP