topic Re: expression is not working on button action in QlikView

expression is not working on button action

Thu, 30 Apr 2015 08:59:28 GMT

Hi All,

Below expression works fine in the text object and shows value properly

=((If(IsNull(Max({$<Year={$(=Max(Year))}>} per)),Week(Now()),

Pick(Match(Max({$<Year={$(=Max(Year))}>}per),

1,2,3,4,5,6,7,8,9,10,11,12),

4,8,13,17,21,26,30,34,39,43,47,52

)

))

But when i'm assigning expression in button action for Set Variable, then if i click button for twice then the proper value is getting:

Variable --> vCYMaxWeek

Value --> =((If(IsNull(Max({$<Year={$(=Max(Year))}>} per)),Week(Now()),

Pick(Match(Max({$<Year={$(=Max(Year))}>}per),

1,2,3,4,5,6,7,8,9,10,11,12),

4,8,13,17,21,26,30,34,39,43,47,52

)

))

Post your experience on this issue.

Thanks in advance

Re: expression is not working on button action

sujeetsingh — Thu, 30 Apr 2015 09:04:32 GMT

May be there might be two or multiple values of the expression ?

Plz share a sample

Re: expression is not working on button action

datanibbler — Thu, 30 Apr 2015 09:08:50 GMT

Hi Satish,

I don't quite understand: That expression looks good, but where does that variable vCYMaxWeek come into play? How should that influence the formula?

=> From the look of it, you have a field > per < that can take the values 1 through 12 or BLANK and depending on that, you generate another field. Right?

Please explain in a little more detail what your issue is. Crystal balls are so hard to come by these days ...

Also, like Albert Einstein already stated "The detailed description of a problem often leads to a solution". This was repeated by Feynman who got the Nobelprice for it, I think, and it does happen to be true ...

Best regards,

DataNibbler

Re: expression is not working on button action

Thu, 30 Apr 2015 09:54:04 GMT

Hi please find my sample attached app.

thanks in advance.