topic Re: Applying Filter To Straight Table in QlikView

Applying Filter To Straight Table

tahirkhalil — Mon, 28 Dec 2015 08:27:53 GMT

I am stuck up with a problem. I want to filter data from straight table based on some variable condition. Please see the attached file and suggest how can I achieve this?

Regards,

Re: Applying Filter To Straight Table

sunny_talwar — Mon, 28 Dec 2015 10:50:21 GMT

I am not sure what is not working in your posted qvw? There is not explanation here or in the qvw which can help us understand your requirement. Do you mind telling us what are you trying to do?

Re: Applying Filter To Straight Table

sunny_talwar — Mon, 28 Dec 2015 10:57:07 GMT

Is the issue with these two buttons?

Try these expressions for 'Select in Field' action:

1) ='(' & Concat(If(Score>=$(Variable1), StoreCode), '|') & ')'

2) ='(' & Concat(If(Score<$(Variable1), StoreCode), '|') & ')'

Re: Applying Filter To Straight Table

tahirkhalil — Mon, 28 Dec 2015 12:24:39 GMT

Great !

This is what I need to achieve.

The only issue left is if all stores are non-compliant the selection does not clear the selection in straight table.

Regards,

Re: Applying Filter To Straight Table

Mon, 28 Dec 2015 13:33:38 GMT

It looks like the issue is no data being filtered when the text boxes are clicked? It appears there is an issue with the actions you have defined.

You could also add a list box using the same expression being usied for the compliance satatus field in the table

=if(Score>=Value,'Compliant', 'Non-Compliant')

Re: Applying Filter To Straight Table

Anonymous — Mon, 28 Dec 2015 14:34:31 GMT

Khalil, the Sunny's proposed solution works fine !

Re: Applying Filter To Straight Table

sunny_talwar — Mon, 28 Dec 2015 15:31:39 GMT

I am not sure what you mean? You mean to say that when everything is non-compliant and someone select Compliant Stores you would not want to see anything in the straight table?

Re: Applying Filter To Straight Table

Anonymous — Mon, 28 Dec 2015 16:16:27 GMT

Sunny & Khalil

I propose an improvement that is before the first 'select in field action' to search by '*' in ' StoreCode ' field . Without this improvement the action does not run immediately, so requiring the button click twice.

Re: Applying Filter To Straight Table

tahirkhalil — Wed, 30 Dec 2015 05:36:40 GMT

Yes - if there is no compliant store, the list box become empty.

I got number of rows in table. if someone increase the value of compliance threshold, sometime, it may happen that all the stores become non-compliant, therefore, the list box should be filtered accordingly showing no rows.

Re: Applying Filter To Straight Table

tahirkhalil — Wed, 30 Dec 2015 11:11:15 GMT

Hi Evandro,

This is still need double click if we dont clear the selection.

Seems * is not working.

Re: Applying Filter To Straight Table

sunny_talwar — Wed, 30 Dec 2015 11:38:40 GMT

May not be the best solution, but look at the attached qvw to see if this is helpful.

Re: Applying Filter To Straight Table

sunny_talwar — Wed, 30 Dec 2015 11:42:15 GMT

I tried this, but this doesn't seem to be helping. Do you have a sample to show where this is working?

Re: Applying Filter To Straight Table

tahirkhalil — Wed, 30 Dec 2015 11:49:16 GMT

Good ! Yes it can be a solution.

Can you please look into the double clicking stuff?

I mean when you press COMPLIANT first time - it will show you all compliant but once you select NON-COMPLIANT it does not exclude the COMPLIANT stores - I tried the solution to select '*' before the actual SELECT FIELD check but even it is not working - we need to double click the button in order to apply the filter.

Re: Applying Filter To Straight Table

sunny_talwar — Wed, 30 Dec 2015 12:53:57 GMT

Yes I have also seen it not working. One potential solution is to create three tables one on top of each other which would always display either COMPLIANT or NON-COMPLIANT or BOTH at any given time. This would still be controlled by the two buttons. Does that sound like a possible solution?

Re: Applying Filter To Straight Table

sunny_talwar — Wed, 30 Dec 2015 13:18:07 GMT

Check the attached application out. There are three charts with conditional hide and show functionality based on the variable that is set by the two buttons.

Re: Applying Filter To Straight Table

tahirkhalil — Thu, 31 Dec 2015 05:46:24 GMT

Hi Sunny,

This is fine but the functionality required is to filter the data. This is just a part of whole dashboard which needs to be updated/filtered according to the button selection.

Can we implement some macro based filtering for this scenario?

Regards,