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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to write set expression

Hi Team,

Please assist me with the below.

I am having the listboxes namely Orderyear(2011,2012...) and ordermonth(Jan,Feb,march..).

I have created a textbox which should display only for the orderyear 2011 sum of sales.

=sum({1<orderyear={2011}>}Sales)

But what I want to include is:

     what ever we select in ordermonth the data sould be 2011+Selectedmonth

Thanks in Advance

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Swathi,

  If I am not wrong your requirement is something like Full value of 2011+ Selected Months Value). I have considered 2016 as a static + Selected month in the appliaction

Find the attachment. Let me know if it helps you

-Jai

View solution in original post

3 Replies
vishsaggi
Champion III
Champion III

May be this?

= sum({$< orderyear = {2011} >} Sales)

Anonymous
Not applicable
Author

Hi Nagaraju,

Thanks for the reply.

What I am expecting the data should display for orderyear =2011, and if I select any ordermonth the data should display accordingly. like 2011+jan etc..

if I select other than order year and ordermonthn then the  data should not change.

Anonymous
Not applicable
Author

Hi Swathi,

  If I am not wrong your requirement is something like Full value of 2011+ Selected Months Value). I have considered 2016 as a static + Selected month in the appliaction

Find the attachment. Let me know if it helps you

-Jai