Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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