topic Re: How to create an expression that only reports back CODES that begin with "S" in QlikView

How to create an expression that only reports back CODES that begin with "S"

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

I am sorry for the newby question, but I want to report back only an Estimate Code that begins with "S". See attached, I only want S000xxx to appear when I have the Sheet open. I have other codes that begin with P and M, but want to exclude.

What would be the expression? If I am asking the correct question...

Thanks

Re: How to create an expression that only reports back CODES that begin with "S"

devarasu07 — Thu, 16 Mar 2017 02:19:58 GMT

Hi Chris,

Try below methods

Method1:

Try like below in your script,

Data:

LOAD * INLINE [

Product,Qty

S000029, 100

S000030, 60

S000011, 50

P000068, 70

P000012, 19

M000128, 120

] Where not WildMatch(Product,'P*','M*');

method 2:

If you wanted to do in your presentation end, then try like below,

in your dimension (add new calculated dimension and enable check box for suppress null value)

=pick(Wildmatch(Product,'S*'),Product)

Hope this helps you

Regards,

Deva

Re: How to create an expression that only reports back CODES that begin with "S"

Thu, 16 Mar 2017 06:01:44 GMT

Hi,

If you want to display product values consisting 'S000' when you open the sheet then

go to setting ---> sheet properties-->edit actions under on activating sheet--> add-->select in field-->enter field as Product and value as S000*

Thanks

Re: How to create an expression that only reports back CODES that begin with "S"

rahulpawarb — Thu, 16 Mar 2017 06:16:56 GMT

Hello Chris,

I agree with Devarasu! Meanwhile you can use below front-end expression:

=If(Left(Product, 4) ='S000', Product)

Hope this will be helpful.

Regards!

Rahul

Re: How to create an expression that only reports back CODES that begin with "S"

Anil_Babu_Samineni — Thu, 16 Mar 2017 07:42:29 GMT

one more solution could be this

Script:

Data:

LOAD * INLINE [

Product,Qty

S000029, 100

S000030, 60

S000011, 50

P000068, 70

P000012, 19

M000128, 120

] Where WildMatch(Product,'S000*');

Front-End:

Only({<Product = {'S000*'} >} Product)

Re: How to create an expression that only reports back CODES that begin with "S"

sasiparupudi1 — Thu, 16 Mar 2017 08:17:54 GMT

Use triggers .

Please see attached qvw .

hth

Sas

Re: How to create an expression that only reports back CODES that begin with "S"

muthukumar77 — Thu, 16 Mar 2017 08:54:06 GMT

Hi,

Go to Sheet Properties,

Add Action - > Select in Field,

Field -> EstimationCode

Search String -> S*

Re: How to create an expression that only reports back CODES that begin with "S"

Thu, 16 Mar 2017 08:56:22 GMT

Hi,

sorry for the mistake in the last post try this:

If you want to display product values consisting 'S000' when you open the sheet then

go to setting ---> sheet properties-->Triggers-->edit actions under on activating sheet--> add-->select in field-->enter field as Product and value as S000*

Thanks