Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ccarlock12
Contributor II
Contributor II

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

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

7 Replies
devarasu07
Master II
Master II

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

Not applicable

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

rahulpawarb
Specialist III
Specialist III

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

Anil_Babu_Samineni

Or

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*');


Or


Front-End:

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

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)
sasiparupudi1
Master III
Master III

Use triggers .

Please see attached qvw .

hth

Sas

muthukumar77
Partner
Partner

Hi,

Go to Sheet Properties,

Add Action - > Select in Field,

Field -> EstimationCode

Search String -> S*

Muthukumar Pandiyan
Not applicable

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