topic Re: Create a Flag that reduces QVW to only show products 'Shebo' in QlikView

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

Anonymous — Thu, 07 Feb 2013 09:53:50 GMT

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

];

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

Gysbert_Wassenaar — Thu, 07 Feb 2013 10:01:47 GMT

Add a line to the load statement:

Groupings:

LOAD *,

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

INLINE [

ProductName, ProductType

CUSTOM\SheboA112, 1

CUSTOM\SheboB1123, 1

...etc..

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

khadeer — Thu, 07 Feb 2013 10:07:31 GMT

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

PFA.

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

Anonymous — Thu, 07 Feb 2013 10:35:54 GMT

Thanks, works great!

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

Anonymous — Thu, 07 Feb 2013 11:28:23 GMT

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?

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

Jason_Michaelides — Thu, 07 Feb 2013 11:46:17 GMT

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

Hope this helps,

Jason

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

Wed, 07 Jan 2015 16:40:20 GMT

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