topic Re: Set analysis with empty values problem in QlikView

Set analysis with empty values problem

Anonymous — Thu, 02 Aug 2018 13:17:38 GMT

Hello,

I use set analysis to filter data. When i try to put a filter in field that contains also empty values in order to exclude 2 values then also the empty values dissapear.

The expression i use is:

sum({< ORDER_StatusDesc= {"CO-Released", "REPLORD-Released"},PRDLI_Desc = {"Die Cut","Die Cut Glued"},MFO_StateDesc -= {"MFO Cancelled","MFO Finished"} >} ORDER_GrossSqm)

In the field MFO_StateDesc i have some records with empty value. When i put in the expression the "MFO_StateDesc -= {"MFO Cancelled","MFO Finished"}" part then the MFO_Cancelled and MFO_Finished are removed but also the empty ones. I don 't want the empty to be removed.

Can any one help.

Re: Set analysis with empty values problem

sunny_talwar — Thu, 02 Aug 2018 14:31:42 GMT

How about this

Sum({<ORDER_StatusDesc= {"CO-Released", "REPLORD-Released"},PRDLI_Desc = {"Die Cut","Die Cut Glued"}, MFO_StateDesc = e({<MFO_StateDesc = {"MFO Cancelled","MFO Finished"}>})>} ORDER_GrossSqm)

Re: Set analysis with empty values problem

Anonymous — Fri, 03 Aug 2018 05:49:46 GMT

Thanks for the reply.

Same effect. The empty values are lost.

Re: Set analysis with empty values problem

sunny_talwar — Fri, 03 Aug 2018 14:13:19 GMT

May be convert nulls to white spaces in the script...

If(IsNull(MFO_StateDesc), ' ', MFO_StateDesc) as MFO_StateDesc

Or you can create a new field for the purposes of this set analysis

If(Match(MFO_StateDesc, 'MFO Cancelled', 'MFO Finished'), 0, 1) as Flag

and then use this

Sum({<ORDER_StatusDesc= {"CO-Released", "REPLORD-Released"},PRDLI_Desc = {"Die Cut","Die Cut Glued"}, Flag = {1}>} ORDER_GrossSqm)