topic Colour change as per the selection in dynamic selection report in QlikView

Colour change as per the selection in dynamic selection report

vikasshana — Wed, 25 Aug 2021 14:48:37 GMT

Hi,

I've dynamic selection report implemented in my organization as "Dim" and "Measure" as two selection boxes and based on the selections in "Dim" and "Measure" Report gets populated. Now requirement is when users select Dimensions from "Dim" List box and measures from "Measure" List box back ground Color has to change. Example as below.

Dim

Test1

Test2

Test3

Test4

Test5

Measure

Sales1

Sales2

Sales3

Sales4

Sales5

Sales6

So for example user selects Test1 and Test2 from Dim and Sales1 and Sales2 from Measure I want the background color of Sales1 and Sales2 has to change when sales2<=Sales1 then Sales1 background color has to be green and when sales2>Sales1 then Sales1 background color has to be red, this logic needs to be applied when ever user selects only sales1 and sales2 from measure. When user selects other measures apart from sales1 and sales2 it has to be default white.

Expected Output:

Regards,

Vikas

Re: Colour change as per the selection in dynamic selection report

chrismarlow — Wed, 25 Aug 2021 18:09:03 GMT

Hi,

Don't know if the dynamic report piece affects this but maybe try something like this;

Cheers,

Chris.

Re: Colour change as per the selection in dynamic selection report

vikasshana — Thu, 26 Aug 2021 06:23:45 GMT

Thanks for that Chris, but it is not working for me and moreover the calculations are happening at the backend so I don't want to use sum(Sales1)>sum(Sales2) in the expression I just want only the fields.

Re: Colour change as per the selection in dynamic selection report

vikasshana — Thu, 26 Aug 2021 12:35:16 GMT

Can someone help me on this as this is a high priority requirement.

@sunny_talwar @Anil_Babu_Samineni @tresB

Re: Colour change as per the selection in dynamic selection report

chrismarlow — Thu, 26 Aug 2021 18:03:37 GMT

Hi,

I think you are going to need to share more about how your dynamic selection report works, dimensions/expressions etc ... particularly if you are precalculating things.

Cheers,

Chris.

Re: Colour change as per the selection in dynamic selection report

vikasshana — Mon, 30 Aug 2021 06:59:14 GMT

Hi,

In my application I've created a data model by extracting fields from different data sources and using the same fields in the script to create a dynamic selection report and in the same way I'm using basic sum(sales) calculations.

Re: Colour change as per the selection in dynamic selection report

vikasshana — Mon, 30 Aug 2021 14:34:54 GMT

Can some one help me on this please.