How can I filter data base on Expression?

[Sokkorn]

Hi All,

I want to create button to filter data by colore. In the attached file, I have create 3 button that need to to filter data base on expression. How can I do this?

Thanks in advanced!

Regards,

Sokkorn Cheav

[its_anandrjs]

Hi,

You need to create a inline table and put this three condition for the colors and use this fields to filter out the data. For Green, Yellow, Red and use this fields to filter the conditions.

Regards,

Annad

[its_anandrjs]

Hi,

Or you do one thing also dont need to create a button to filter the data of the Green, Yellow, Red i suggest you to create a Resident table and load the table with your Green, Yellow, Red condition like this

Load

*,

IF([Call Setup]>='95.00%','Green',

IF([Call Setup]<'95.00%' and [Call Setup]>='74.00%' ,'Yellow',

IF([Call Setup]<'74.00%','Red'))) as FilterField

Resident TableName;

Regards,

Anand

[its_anandrjs]

Hi,

See the attached sample file might be it is your solution i thing.

Lets see i create this sample because i am not able to load your QVW file.

Regards

Anand

[Sokkorn]

Hi Anand,

Thanks for your reply. Your anwser is help me so much, but it still not fit with my requirement. I try with your solution.

Regards,

Sokkorn

[its_anandrjs]

Hi,

There is anothere solution for you also lets try this and let me know. I create one variable named vOne and by selecting the button it display the Green, Red,  Yellow data but it display only see the attached sample file let me know whether it works for you or not.

I put this condition on your condition add variables and by selectiob the button it will change.

IF([Call Setup]>='95.00%' and vOne=1,Green(),

IF([Call Setup]<'95.00%' and [Call Setup]>='74.00%' and vOne=2 ,Yellow(),

IF([Call Setup]<'74.00%'and vOne=3,LightRed())))

Click on button one by one and check it, see Solution Sheet.

Regards

Anand

[Sokkorn]

HI Anand,

I cannot find the variable vOne in the attached. Can you do it agin for me.

Many thanks for your help.

Regards,

Sokkorn

[its_anandrjs · Accepted solution]

Hi,

If you want to see the variables you need to press Ctrl + Alt + V and set different values for color like 1,2,3 of variable vOne and change the colors of the chart.

See the attached sample.

Regards

Anand

[Sokkorn]

Hi Anand,

This one is help me so much. One more can I hide or exclude from chart where the value don't have color?

Regards,

Sokkorn

[its_anandrjs]

Hi,

I thing for that you need to create a resident table for that and create a another column as which mantains this colors in resident table like in this code

Load

*,

IF([Call Setup]>='95.00%','Green',

IF([Call Setup]<'95.00%' and [Call Setup]>='74.00%' ,'Yellow',

IF([Call Setup]<'74.00%','Red'))) as FilterField

Resident YourTableName;

Regards,

Anand