topic Re: link button and expression in QlikView

link button and expression

Anonymous — Mon, 28 Sep 2015 14:23:36 GMT

I have two buttons ; one monthly and the another yearly

I have two expressions

exp1

= SUM({<DateTest = {">=$(=Date(yearStart(Today())))<=$(=Date(Today()))"}>}[Prix de vente TTC])

+

SUM({<[Date Time] = {"<=$(=Date(MonthEnd(Today())))>$(=Date(Today()))"}>}[CA TTC])

exp2

= SUM({<DateTest = {">=$(=Date(yearStart(Today())))<=$(=Date(Today()))"}>}[Prix de vente TTC])

+

SUM({<[Date Time] = {"<=$(=Date(yearend(Today())))>$(=Date(Today()))"}>}[CA TTC])

How can I link buttons monthly with exp1 and yearly with exp2 ? when I choose monthly i get result from exp1 and when I choose yearly I get result from exp2 ?

Re: link button and expression

jonathandienst — Mon, 28 Sep 2015 14:30:41 GMT

Assign the button actions to set a variable (lets call it vYMSelect). Yearly button sets this variable to 2, Monthly button sets it to 1.

Then use this expression:

= SUM({<DateTest = {">=$(=Date(yearStart(Today())))<=$(=Date(Today()))"}>}[Prix de vente TTC])

+ If(vYMSelect = 1,

SUM({<[Date Time] = {"<=$(=Date(yearend(Today())))>$(=Date(Today()))"}>}[CA TTC]),

SUM({<[Date Time] = {"<=$(=Date(MonthEnd(Today())))>$(=Date(Today()))"}>}[CA TTC])

)

Re: link button and expression

rubenmarin — Mon, 28 Sep 2015 14:33:42 GMT

Hi, you can add a variable "vYearlyMonthlySelector", the 'Monthly' button sets its value to 'M', and the yearly button to 'Y'

Then you can use this variable value to configure your expression:

If(vYearlyMonthlySelector='M', [exp1], [exp2])

Or you can use it in conditional expression textbox.

Hope this helps.