topic Re: Select in field trigger search string help in QlikView

Select in field trigger search string help

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

Hi,

I have a field Prod_Type in my database and it has two values:

1. New Product

2. Old Product.

I have to display sales value for both products or any one which is selected. So I have created a InLine table with three values:

ALL

NEW

OLD

I am displaying these three values in List Box in qlikview and user can select any one of the three values and the functionality is as below:

1. When user selects NEW or OLD from list box, I have written Document Trigger to select New Product or Old Product from Prod_Type field.

2. When user select ALL from list box, I am clearing any selection from Prod_Type field.

This is working fine till now.

Now there is a scenario:

Now in database table in Prod_Type field we do not have New Product data. So we have only Old Product data in database table.

So when in Qlikview dashboard user is selecting NEW from list box, Qlikview is displaying data for Old Product because it has not found New Product.

Is there any solution for this issue.

Thanks for your help.

Re: Select in field trigger search string help

Miguel_Angel_Baeyens — Mon, 11 Sep 2017 14:01:23 GMT

Perhaps some data would help to understand the issue. If there are only two possible values for Prod_Type, why use a trigger in the first place? The user can already select NEW or OLD using that field and select both (so both values will be in green) or none (both values will be in white) to see both NEW and OLD altogether.

Re: Select in field trigger search string help

musketeers — Mon, 11 Sep 2017 14:06:34 GMT

Hi, Thanks for your reply. Actually your thoughts are correct. But since Users need ALL keyword to select every thing, thats why I have created the inline table and I am using triggers to connect inline table selection with the database field.

Till now this was working fine, but now they have changed the data and now it does not contain value for New Product, so now it is not working.

But still users want to see these three values from inline table and when they will select NEW, dashboard should display 0 (Zero) for sales sum because there is no New Product now in database.

Thanks

Re: Select in field trigger search string help

effinty2112 — Mon, 11 Sep 2017 14:19:16 GMT

Hi Rajneesh,

Instead of a table with fields [New Product],[Old Product] why not have a table of products with fields Product and Status:

Product Status

1000 New

1001 New

ABC1 Old

ABC2 Old

Selecting the status as old or new or not having a selection in this field should work for you. If you want to keep the connection between old and new you could add a third column, Alternative Code.

Cheers

Andrew

Re: Select in field trigger search string help

swuehl — Mon, 11 Sep 2017 14:28:16 GMT

Create a link table that links your Prod_Type to your list box values:

LOAD * INLINE [

Prod_Type, Selection_ListBox

New Product,ALL

Old Product,ALL

New Product, NEW

Old Product, OLD

];

Now you don't need any triggers and selecting NEW should result in zero for Sum(Sales).

Re: Select in field trigger search string help

musketeers — Mon, 11 Sep 2017 14:37:27 GMT

Hi Stefan,

Thanks for your help. It is working very fine. Thanks again.