Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
chrisgoudy
Contributor II
Contributor II

Create a Flag that reduces QVW to only show products 'Shebo'

I have a model that shows specific products

The products are loaded into the script using a Load Inline Statement.

I want to create a Flag in the script that when selected reduces the QVW to a specific product, Shebo.

Here is a sample script:

Groupings:

LOAD * INLINE [

    ProductName, ProductType

    CUSTOM\SheboA112, 1

    CUSTOM\SheboB1123, 1

    CUSTOM\SheboC1124, 2

    CUSTOM\SheboD1125, 2

    CUSTOM\SheboE1126, 3

    CUSTOM\ProlineA1127, 1

    CUSTOM\ProlineB1128, 1

    CUSTOM\ProlineC1129, 2

    CUSTOM\YealinkA11210, 2

    CUSTOM\YealinkB11211, 2

    CUSTOM\YealinkC11212, 3

];

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Add a line to the load statement:

Groupings:

LOAD *,

wildmatch(ProductName, '*Shebo*') as SheboFlag

INLINE [

    ProductName, ProductType

    CUSTOM\SheboA112, 1

    CUSTOM\SheboB1123, 1

...etc..


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
Gysbert_Wassenaar

Add a line to the load statement:

Groupings:

LOAD *,

wildmatch(ProductName, '*Shebo*') as SheboFlag

INLINE [

    ProductName, ProductType

    CUSTOM\SheboA112, 1

    CUSTOM\SheboB1123, 1

...etc..


talk is cheap, supply exceeds demand
khadeer
Specialist
Specialist

=if(WildMatch( SubField(ProductName,'\',2),'Shebo*'),ProductName) as FLAG

PFA.

chrisgoudy
Contributor II
Contributor II
Author

Thanks, works great!

chrisgoudy
Contributor II
Contributor II
Author

Can I use the field SheboFlag in my charts with Set Analysis or something so the charts only show Shebo Products?

Is it possible to do this without making any selections?

Jason_Michaelides
Luminary Alumni
Luminary Alumni

Sum({<SheboFlag={1}>} Sales)

Hope this helps,

Jason

Not applicable

I have a similar query.  I don't want to reduce the data in my document.  I have a field within my document called 'Active_Dir_User' that also corresponds to an 'Employee_Name' field.  What I need to do is when the document opens, I need the Employee_Name field to be filtered using the Active_Dir_User and OsUser() information...

Can this be achieved without going down the Section Access route??

Many thanks

Tom