Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Wildmatch not working in expression

Hi to everyone!

I have a table with column:

Previous month sales. Expression:

Sum({$< DateSale=, MonthSale=, YearSale=, DateSale = {'>=$(=vStartPrevPeriod_month) <$(=vMinSelectedDate)'},

Field1={'2937.3'}, Field2={"=WildMatch(Field2,'841*','831*','811*','3350')"} >} SUM)/1000


I select YearSale=2015

MonthSale=September


vStartPrevPeriod_month=01.08.2015

vMinSelectedDate=01.09.2015



So, I analyze sales in August month of 2015.


Problem: Expression does not take values of Field1=2937.3 and Field2=8113,8114 in period of august 2015. They exist in my qvd.

But with other values it works good.


Please help. How to solve it. May be there is another funtion like WildMatch.. I also tried 'LIKE' function. The result is the same.





Tags (1)
1 Solution

Accepted Solutions

Re: Wildmatch not working in expression

Hi,

try this

Sum({$< DateSale=, MonthSale=, YearSale=, DateSale = {'>=$(=vStartPrevPeriod_month) <$(=vMinSelectedDate)'},

Field1={'2937.3'}, Field2={'841*','831*','811*','3350'} >} SUM)/1000

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

3 Replies

Re: Wildmatch not working in expression

Hi,

try this

Sum({$< DateSale=, MonthSale=, YearSale=, DateSale = {'>=$(=vStartPrevPeriod_month) <$(=vMinSelectedDate)'},

Field1={'2937.3'}, Field2={'841*','831*','811*','3350'} >} SUM)/1000

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

SreeniJD
Valued Contributor

Re: Wildmatch not working in expression

Hi Iskander,

apply NUM# function for Field1 and Field2. This might works!

HTH,

Sreeni

Not applicable

Re: Wildmatch not working in expression

Thank you very much! It works.

I made it so complicated)..