topic Re: Set Analysis multiple condition issue in QlikView

Set Analysis multiple condition issue

0li5a3a — Sat, 16 Nov 2024 03:17:06 GMT

Hi there,

Can someone tell my what is wrong with the below set analysis expression ?

I have a Straight table and I am trying to use this expression to restrict the data

If I use the below formula all the restriction before Actual_End.RelativeMonth = {'0'}> + <WO_Actual_End_Date = {'-'} are ignored and I don't understand why.

Count({<Customer = {'ABC'}, [Ticket Category] = {'Incident'}, Created.RelativeMonth -= {'0'}, Actual_End.RelativeMonth = {'0'}> + <WO_Actual_End_Date = {'-'} >} WO_Created_Date)

The logic is:

if Customer = ABC and Ticket Category = Incident and Created Month is NOT Current Month( I take this from Calendar) and The End date is Current month or End Date field is " - ", count the WO_Created_Date.

Thanks in advance

Re: Set Analysis multiple condition issue

sunny_talwar — Mon, 17 Jun 2019 12:37:52 GMT

It might be easy to resolve if you are able to share a sample for us to see.

Re: Set Analysis multiple condition issue

0li5a3a — Mon, 17 Jun 2019 13:12:05 GMT

Sorry but I can't copy and paste the code from my app.

I don't understand how to use "OR" in set analysis

I have found something like End.RelativeMonth = {'0'}> + <End_Date = {'-'} but if I put this condition all the other condition are not counted.

Count({<Customer = {'ABC'}, [Ticket Category] = {'Incident'}, Created.RelativeMonth -= {'0'}, End.RelativeMonth = {'0'}> + <End_Date = {'-'} >}Created_Date)

Created.RelativeMonth is a new field based on the master calendar and aso End.RelativeMonth.

End_Date and Created Date are the fields which I use to create the masters calendars.

Re: Set Analysis multiple condition issue

sunny_talwar — Mon, 17 Jun 2019 13:14:36 GMT

May be try this

Count({<Customer = {'ABC'}, [Ticket Category] = {'Incident'}, Created.RelativeMonth -= {'0'}>*(<End.RelativeMonth = {'0'}> + <End_Date = {'-'}>)}Created_Date)

or this

Count({<Customer = {'ABC'}, [Ticket Category] = {'Incident'}, Created.RelativeMonth -= {'0'}, End.RelativeMonth = {'0'}> + <Customer = {'ABC'}, [Ticket Category] = {'Incident'}, Created.RelativeMonth -= {'0'}, End_Date = {'-'}>}Created_Date)

Re: Set Analysis multiple condition issue

0li5a3a — Mon, 17 Jun 2019 13:19:02 GMT

many thanks! all good now 🙂

Test

mgajja2019 — Mon, 17 Jun 2019 13:34:16 GMT

Just testing the discussion board