topic Expression in QlikView

Expression

Sat, 05 Mar 2011 12:07:40 GMT

hi,

I am having three sliders based and one Barchart in my sheet.

Now i required is when i select the first slider the barchart should changes it value according to that selection of Slider1.

Again when i select the second slider the barchart should changes it valus according to that selection of Slider2.

In the same way ,for the Third Slider also.

How can i write an expression for barchart that should have relation with Three sliders.

Can anyone help in this question.

thnks

Expression

sunil2288 — Sat, 05 Mar 2011 12:16:12 GMT

Hi Venkat...

take 3 variables...

Once u done with changes that has been effected by 1st variable from 1st slider put on deselect clear all.

Then again for the 2nd slider and third slider...

Hope it help u..

Regards...

Expression

Sat, 05 Mar 2011 12:31:33 GMT

Thanks for your reply, but i didn't understand what you said. Actually i am new QlikView.

Sunil, how can i place ExpConditions(see below condt's) in a single Expression Tab. If i am using "OR" it is showing wrong values, otherwise can i use "IF" condition or else some other conditions ?

Count

({$<[$(=GetCurrentField([IMMGroup]))] = {">=$(g2ImmVar1)<=$(g2ImmVar2)"}>} [CT Key]) / / Slider1

Count({$<[$(=GetCurrentField([DoseGroup]))] = {">=$(g2DoseVar1)<=$(g2DoseVar2)"}>} [CT Key]) // Slider2

Count({$<[$(=GetCurrentField([PreCureGroup]))] = {">=$(g2PreCureVar1)<=$(g2PreCurerVar2)"}>} [CT Key]) // Slider3