topic Re: Multiple Field Selection in Set Analysis in QlikView

Multiple Field Selection in Set Analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I have one variable with set Analysis - and I have to make some selections for this value:

I tried it with the following Version (the yellow marked parts are the filters - but the values didn't changed:

if (ValueList('OpenOrders','BackOrders','Incoming Orders','NetSales') = 'OpenOrders',
num(((sum({<$(vClearCalendar),

ERDAT.LIPS = {">=$(=monthend(makedate(Year,$2,1)))"} ,

ABGRU.VBAP={"*"},

AUART.VBAK={"ZTA","ZWEB","ZMU","ZKL","ZIC"},

LFSTA.VBUP={"nicht bearbeitet","teilweise bearbeitet"}

>}OrderValue$(vCurrency).VBAP)

sum({<$(vClearCalendar),

ERDAT.LIPS = {">=$(=monthend(makedate(Year,$2,1)))"},

ABGRU.VBAP={"*"},

AUART.VBAK={"ZTA","ZWEB","ZMU","ZKL","ZIC"},

LFSTA.VBUP={"nicht bearbeitet","teilweise bearbeitet"}>} DeliveryValue$(vCurrency).LIPS))

sum({<$(vClearCalendar),beliefert.VBAP = {0}>}OrderValue$(vCurrency).VBAP))/$1,'#.##0'),

How do I have to include this filters?

Thank you a lot for your help!

Best regards,

Barbara

Re: Multiple Field Selection in Set Analysis

sunny_talwar — Wed, 12 Oct 2016 16:00:07 GMT

Those filters look right, what is the issue? They are not restricting your data? Would you be able to provide a sample where we can see them not working?

Thanks,

Sunny

Re: Multiple Field Selection in Set Analysis

Anil_Babu_Samineni — Wed, 12 Oct 2016 16:09:58 GMT

What is the variable of vClearCalendar and vCurrency

And then remove the

num(((sum({<$(vClearCalendar) -- What is the use of (( here

- ANIL

Re: Multiple Field Selection in Set Analysis

Thu, 13 Oct 2016 06:53:18 GMT

No, they are not restricting the data...

Could it be, that it's hard-coded?

Thanks

Barbara

Re: Multiple Field Selection in Set Analysis

Thu, 13 Oct 2016 06:55:18 GMT

vClearCalendar is a variable which "deletes" the default-date. the previous day is set as Default date. But for this KPI this date is not needed...

vCurrency is for switching currency between Local currency and EUR

But this both variables are not important for this issue I think..

Thanks,

Regards,

Barbara

Re: Multiple Field Selection in Set Analysis

sunny_talwar — Thu, 13 Oct 2016 17:00:59 GMT

Would you be able to share a sample to look at?