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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

using >= in set analysis

Hi All ,

i am trying to use the below function in Qlik View and get an error

 

sum({$<yearmonthvalue

>={201201}>} amount*(1+taxrate))

i need the year moth value where all the data can be pulled greater than and equal to 2012

>=201201

can anyone please help me what is wrong in the expression

Regards

Viral

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Viral,

Try this: {<yearmonthvalue={'>=201201'}>}

or

{<yearmonthvalue={"$(='>=' & '201201')"}>}

Regards,

Michael

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Viral,

Try this: {<yearmonthvalue={'>=201201'}>}

or

{<yearmonthvalue={"$(='>=' & '201201')"}>}

Regards,

Michael

Not applicable
Author

Thanks very much Michael .. It worked.

Regards,

Viral