topic query with wildmatch function in QlikView

query with wildmatch function

hopkinsc — Mon, 12 Sep 2011 11:57:54 GMT

Hi,

can anyone help me with a widmatch function?

I am using this expression in a ListBox:

=if(wildmatch(Narrative,'Goods*')>0,'Goods Received',Narrative)

What i want to do is use this expression but when StockQty is greater than ZERO (>0)

Then i want to use a simular expression...

=if(wildmatch(Narrative,'Goods*')>0,'Goods Returned',Narrative)

but when StockQty is less than ZERO (<0)

So what i want to end up with is a List Box displaying 2 description:

Goods Received (which will show all positive values)

Goods Returned (which will show all negative values)

Can anyone tell me how i can do this please?

Re: query with wildmatch function

SunilChauhan — Mon, 12 Sep 2011 12:25:21 GMT

may be you require this

if(wildmatch(Narraative,'Good*') and StockQty >0,'Good recieved',

if(wildmatch(Narraative,'Good*') and StockQty <0,'Good Return'))

see the attached file

query with wildmatch function

hopkinsc — Mon, 12 Sep 2011 12:33:13 GMT

Thats excellebt, thanks very much

I have another question tho in regards to the Wildmatch function..

How would i set an action to select any 'Goods*' narrative?

What i want is when the user clicks on a Goods Received button, any narratived with 'Goods*' will be selected.

I have tried using the SELECT IN FIELD option, and choosing Narrative for the field, and the search string....

=WildMatch(Narrative,'Goods*')
but i can't get it to work, What am i doing wrong?

query with wildmatch function

SunilChauhan — Mon, 12 Sep 2011 12:40:10 GMT

i belieeve no need to set an action to select

if you apply on ur data properly then it will select all good * when seleect Goods Received

u can also select from list box

or else share the sample

query with wildmatch function

hopkinsc — Mon, 12 Sep 2011 12:45:03 GMT

Hi, yes i know that, but i want the user to make as little selections as possible. My app shows not only goods received, it shows :

Goods received

Wastage

Reductions

Stock Checking

Stock Variances

Each reason has its own page, so when the user click on the Goods received page i want it to automatically select all narratives for 'Goods*'. Then the user only has 2 option to choose from:

Goods received

Goods Returned.

Thanks

Re: query with wildmatch function

hopkinsc — Mon, 12 Sep 2011 12:50:21 GMT

Please see attached

Re: query with wildmatch function

SunilChauhan — Mon, 12 Sep 2011 12:58:07 GMT

hello

i am not know how to write action on button

but you can cheeck this using a list box

see the attached file

meanwhile i looking into action

Re: query with wildmatch function

hopkinsc — Mon, 12 Sep 2011 13:07:18 GMT

Thanks, but thats not what i want. I want the button to select it. But thanks for your help.

I'll start another discussion..