topic Re: set analysis help in QlikView

set analysis help

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

Hi Everybody

Need a little bit of help with this set analysis expression

In my bar chart that is made for errors. I want to show all desc, PNO, that are less than 9 digits or contain a “?”

IF(LEN(PNO)<9 OR wildmatch( REPLACE(PNO,'?','@'), '*@*') ,LIGHTRED(),WHITE())

This is what I have used

sum({$<ProductCode={"???"}>}SPAMT)

This is for my bar chart to show the number of sales processed with incorrect data

Would it be possible to fuse these two expressions together??

prieper — Wed, 03 May 2017 14:24:05 GMT

some sample data would be helpful.

Have you taken the first expression for the background? White on White?

The other expression may be correct from the syntax, but am missing the content.

aaronnayan — Wed, 03 May 2017 14:26:53 GMT

sum({$<ProductCode={"???"}>}SPAMT)

but i want it to also filter for anything <9 charaters

Anil_Babu_Samineni — Wed, 03 May 2017 14:31:37 GMT

May be this?

sum({$<ProductCode={"???"}, PNO = {'$(=Len(PNO)<9)'}>}SPAMT)

sum({$<ProductCode={"???"}, PNO = {=Len(PNO)<9}>}SPAMT)

aaronnayan — Wed, 03 May 2017 14:46:07 GMT

no thats not quite right, the 2nd one there is an error the last part

the first one is correct but it is not picking up anything

please help

Anil_Babu_Samineni — Wed, 03 May 2017 16:15:00 GMT

Is there any chance to share Application for reference

aaronnayan — Wed, 03 May 2017 16:16:24 GMT

sorry no can do

Digvijay_Singh — Wed, 03 May 2017 16:26:23 GMT

May be -

sum({$<ProductCode={"*???*"},PNO={"=LEN(PNO)<9"}>}SPAMT)

Anil_Babu_Samineni — Wed, 03 May 2017 16:28:19 GMT

First, try with this?

sum({$< PNO = {'$(=Len(PNO)<9)'}>}SPAMT)

sunny_talwar — Wed, 03 May 2017 16:32:11 GMT

May be this

Sum({$<ProductCode={"???"}, PNO = {"=Len(PNO)<9 OR WildMatch(Replace(PNO,'?','@'), '*@*')"}>}SPAMT)