Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression is not working on button action

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

3 Replies
sujeetsingh
Master III
Master III

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

Plz share a sample

datanibbler
Champion
Champion

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

Not applicable
Author

Hi please find my sample attached app.


thanks in advance.