Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hey Marco to some extent you are right but the id life numbers are wrong
I need sum of ID life
Hello Stefan the expression is the main one all it matters
Thanks
Hi,
maybe like this?:
hope this helps
regards
Marco
Hello Macro the sum of ID Life (EXPRESSION)still does not match if you check ID 111111
APPRECIATE YOUR HELP