Setting values dynamically.

[deepakqlikview_123]

Hi All,

Please find attached excel as per requirement I want to set   highlighted values dynamically.

Can you please suggest how should i proceed so that I am able to set values as per requirement.

Thanks,

Deepak

Message was edited by: deepak tibhe

[deepakqlikview_123]

Hello Expert,

Can you please help me out on this.

Thanks,

Deepak

[tresesco]

QlikCommunity Tip: How to get answers to your post?

If you want to be helped, you have to help others understand your requirement.

[deepakqlikview_123]

Thanks Tresco

done now.

Thanks

[hannan_t]

Can you explain it in a bit more detail.

You want to set variables on highlighted values but is there any logic behind these values?

Or you just want the values in these columns to be highlighted?

[deepakqlikview_123]

Hi Tariq,

Thanks for response.

There is no logic currently I have only sample data  in excel that I have attached..

I just need to set highlighted values dynamically.

Is there need to use any variable if so how shall I proceed.

thanks

[hannan_t]

You need to activate highlight on any value based on some logic.

For example if you want to set a variable on Existing Policies field that if the value in this field is equal to or greater than 20,000 then the field color turns yellow if less then 20,000 then it turns red.

For this purpose you can use conditional color option.

Look into the attached example.

I have applied condition on background color of the expression

[hannan_t]

I have used the If condition in the background color expression, you can use the same expression in the variable and use that variable in background color expression.

[deepakqlikview_123]

Hi Hannan,

Thanks for response.

But my requirement is how to change backend data value.As currently i am  using excel as source data by using variable is it possible to set new vaue ,please suggest.

thanks

[hannan_t · Accepted solution]

It is possible to set the parameters for calculation on the data but to change the values in data is supposed to happen in database by the database administrators. In BI we don't change the original data. The original data is in the ownership of the client and only client should change it. This is the best practice I guess.