topic Re: Dynamically Change the Expression Label in QlikView

Dynamically Change the Expression Label

Mon, 29 Jun 2015 08:14:08 GMT

All,

Good Day...

I am making a pivot table with 3 dimension and 2 expression.

The dimension are

Customer Code

Customer Name

Air Line

The Expression are

Amount

Incentive

I want an option to dynamically change the name of this Incentive based on the dimension Airline, if the air line is A, then i need

Incentive as "Incentive -10%", if the Airline is B, incentive should be "Incentive-20%" and go on..

Appreciate your help

Thanks

Re: Dynamically Change the Expression Label

MK_QSL — Mon, 29 Jun 2015 08:19:15 GMT

Is there any on AirLine selected at a time?

If Yes, you can use something like below in lable

=If(GetFieldSelections([Air Line]) = 'A', 'Incentive -10%', 'Incentive - 20%')

Re: Dynamically Change the Expression Label

jsingh71 — Mon, 29 Jun 2015 08:19:19 GMT

Please share some sample data then will try to implement this.

Re: Dynamically Change the Expression Label

Mon, 29 Jun 2015 08:23:13 GMT

No, I cannot select a particular Airline. Need to make it dynamic..

Re: Dynamically Change the Expression Label

Mon, 29 Jun 2015 08:43:23 GMT

Hi,

i have attached a sample file. Please have a look on that.

Re: Dynamically Change the Expression Label

Mon, 29 Jun 2015 08:43:45 GMT

I have attached a sample file..

Re: Dynamically Change the Expression Label

buzzy996 — Mon, 29 Jun 2015 08:44:47 GMT

Hi Ranjith, we have to tell the system/ur chart some way u changed some thing(accordingly ur changes ur chart expressions also will change),but ur saying to MRKachhiaIMP question answer as NO,if that is the case how ur system will understand something is dynamically changed?

u can use the option suggested by MRKachhiaIMP

else u can create a variable with input box,and pass ur values as Airline A or B, and in ur expression u can us ethis variable and write ur conditions.

Re: Dynamically Change the Expression Label

Mon, 29 Jun 2015 08:59:03 GMT

Okay Shiva,

Let me try like that...