Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
ferha_jafri
Partner - Creator III
Partner - Creator III

issue with year selection

Hello everyone,

I have an issue as i want to get values such that when i select year the value should get the values from 1-1-of selected year till 3-9-selected year means date of today but year is the selected year . Plz  help it is urgent.

Thanks in advance

Ferha Jafri

10 Replies
Not applicable

Hey, i had to do something similar to analyze this year vs last year on the same period.

=sum( {1< YEAR={$(=(num(Year(TODAY()))))}, PERIOD_NUM= {'>=1<= $(=(num(Month(Today())-1)))'}>  }PERIOD_ACTIVITY)

Try to adapt the code to your case adding a set analysis also for day

p.s. Period num is my Month Field