topic How can you do conditional actions? (without macro) in QlikView

How can you do conditional actions? (without macro)

andrea_derossi — Tue, 10 Jan 2012 11:26:45 GMT

Hi All,

Scenario: I have a button with 10 actions (for example 10 selections or other but not macro).

One example: if the filed doesn't have any selectable value then I need to skip the other actions, and write one varible that i use as alert.

is It possible?

Thanks all

Andrea

How can you do conditional actions? (without macro)

stephencredmond — Tue, 10 Jan 2012 13:37:43 GMT

Hi Andrea,

You can't put a conditional branch in a sequence of actions without macros. However, what you might want to consider is having different buttons visible depending on conditions. That might solve your issue.

Regards,

Stephen

Re: How can you do conditional actions? (without macro)

Fri, 13 Jan 2012 16:28:38 GMT

I recently needed similar funcionality and resolved it using the following in my actions:

=if(GetPossibleCount(Field)>0,Field,0)

Re: How can you do conditional actions? (without macro)

Tue, 23 Jul 2013 13:05:24 GMT

Just in case anyone else stumbles upon this, the solution I've used is to set a variable

vDateSelection=

if(

isNull(GetFieldSelections(Date.Year_Month)),

vMTD,

'("'& Concat(DISTINCT(Date.Year_Month),'"|"') & '")'

)

I then set Date.Year_Month to vDateSelection when I go on to a tab.

regards

Graham