topic Re: How to write set expression in QlikView

How to write set expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to write set expression

vishsaggi — Fri, 03 Nov 2017 15:16:59 GMT

May be this?

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

Re: How to write set expression

Anonymous — Wed, 08 Nov 2017 05:14:39 GMT

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.

Re: How to write set expression

Anonymous — Wed, 08 Nov 2017 10:32:39 GMT

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