Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
aaronnayan
Contributor III

set analysis help

     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??

9 Replies
prieper
Honored Contributor II

Re: set analysis help

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
Contributor III

Re: set analysis help

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


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

Re: set analysis help

May be this?

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

Or

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
aaronnayan
Contributor III

Re: set analysis help

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

Re: set analysis help

Is there any chance to share Application for reference

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
aaronnayan
Contributor III

Re: set analysis help

sorry no can do

Digvijay_Singh
Honored Contributor III

Re: set analysis help

May be -

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

Re: set analysis help

First, try with this?

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


Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: set analysis help

May be this

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