Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
aaronnayan
Creator III
Creator 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
Master II
Master II

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
Creator III
Creator III
Author

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


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

Anil_Babu_Samineni

May be this?

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

Or

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
aaronnayan
Creator III
Creator III
Author

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

Is there any chance to share Application for reference

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
aaronnayan
Creator III
Creator III
Author

sorry no can do

Digvijay_Singh

May be -

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

Anil_Babu_Samineni

First, try with this?

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


Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

May be this

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