topic Re: Need Help in QlikView

Need Help

paulwalker — Mon, 20 Jul 2015 03:40:45 GMT

HI Community,

Variable Event Trigger not working in my Application.

I have created one Trigger, If i am click MonthList field and input field i want to effect to chart..

PFA,

Thanks in Advance...

Re: Need Help

tresB — Mon, 20 Jul 2015 04:42:44 GMT

Couple of issues :

The variable definition could be simplified
Trigger field should be DATE rather than MonthList

Not really sure about your exact expected output. May be you can start like I showed in attached sample.

Re: Need Help

paulwalker — Mon, 20 Jul 2015 11:06:53 GMT

Hi Tre,

Is it possible to Effect only Variable Event Trigger.

based on MonthList selection and variable..

Expression should be Count({<Date = {'6/29/2015'}>}ID) or Count(Distinct ID)

I want to effect based on Trigger,... If i am use expression, don't need trigger

is it possible..????

Re: Need Help

tresB — Mon, 20 Jul 2015 11:16:10 GMT

Sorry, could not get your requirement. Could you explain a bit more?

Re: Need Help

paulwalker — Mon, 20 Jul 2015 11:25:10 GMT

Here, we are using this expression in Barchart.

=count(distinct (if($(vMonthList)>=Date-$(v3) and $(vMonthList)<=Date-$(v4), ID)))

this expression works fine to me... but

if we are using this expression, no need Variable event trigger right?

Actually my requirement i want effect chart based on Trigger...

This expression i am using in Trigger

=if($(vMonthList)>=Date-$(v3) and $(vMonthList)<=Date-$(v4), DATE)

Chart expression Should be Count(Distinct ID)

is it possible???

Re: Need Help

nagarjuna_kotha — Mon, 20 Jul 2015 11:37:10 GMT

FYI..................

Re: Need Help

tresB — Mon, 20 Jul 2015 11:56:47 GMT

I guess there would be a simpler approach to your solution, which could have been suggested with more more info. However, not going into that try trigger expression like:

='('&Concat(distinct if($(vMonthList)>=Date-$(v3) and $(vMonthList)<=Date-$(v4), DATE),'|')&')'

with v3 and v4

PFA