topic Making selection by clicking on text box in QlikView

Making selection by clicking on text box

Anonymous — Sun, 17 Sep 2017 07:14:56 GMT

Colleagues, good day!

I have one small table with Sales data, Sales for checking data and difference between these two fields.

I have 3 text boxes counters, which show qty of ID with equal sales (green), almost not equal (red), almost equal (orange) and no data (Grey).

Is it possible to select ID by clicking on text boxes counters?

For example, if i click on Red counter, pivot should show me only records..

Thanks for advices.

There's test file and qvw in the attachment.

antoniotiman — Sun, 17 Sep 2017 08:04:24 GMT

Hi,

see Attachment.

Regards,

Antonio.

Anonymous — Sun, 17 Sep 2017 11:31:52 GMT

Great!

Thanks a lot!

jerryyang756 — Sun, 17 Sep 2017 12:23:44 GMT

You have to set a trigger on every color named Text Object.

Right Click on text object-> Action-> Add -> Select in Field Action

Now Insert the key field name in the Field area here it is --> ID

Now Insert the ID values for respective colors RED-2,4,6 into the
Search String - (2|4|6) .

Please Check the attachment .