topic Re: Setting values dynamically. in QlikView

Setting values dynamically.

deepakqlikview_123 — Thu, 21 Aug 2014 06:38:52 GMT

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

Re: Setting expression values dynamically.

deepakqlikview_123 — Thu, 21 Aug 2014 07:56:56 GMT

Hello Expert,

Can you please help me out on this.

Thanks,

Deepak

Re: Setting expression values dynamically.

tresB — Thu, 21 Aug 2014 08:00:45 GMT

QlikCommunity Tip: How to get answers to your post?

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

Re: Setting values dynamically.

deepakqlikview_123 — Thu, 21 Aug 2014 08:07:26 GMT

Thanks Tresco

done now.

Thanks

Re: Setting expression values dynamically.

hannan_t — Thu, 21 Aug 2014 08:07:33 GMT

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?

Re: Setting values dynamically.

deepakqlikview_123 — Thu, 21 Aug 2014 08:11:10 GMT

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

Re: Re: Setting values dynamically.

hannan_t — Thu, 21 Aug 2014 08:51:02 GMT

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

Re: Re: Setting values dynamically.

hannan_t — Thu, 21 Aug 2014 08:53:24 GMT

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.

Re: Setting values dynamically.

deepakqlikview_123 — Thu, 21 Aug 2014 10:02:13 GMT

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

Re: Setting values dynamically.

hannan_t — Thu, 21 Aug 2014 11:59:18 GMT

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.

Re: Setting values dynamically.

deepakqlikview_123 — Thu, 21 Aug 2014 12:02:02 GMT

Thanks Tariq