topic Formula Syntax in App Development

Formula Syntax

qlikviewaf — Tue, 13 Mar 2018 14:31:27 GMT

=Sum({<Month_Surgery={$(=concat(chr(39) & Month & chr(39),',') )},Year_Surgery={$(=concat(chr(39) & Year & chr(39),',') )},Day=,Year=,Month=,Quarter=>}WI_EUR)/1000

Hi Guys,

i have the formula above as you can se the Month_Surgery and the Year_Surgery is defined based on the Month and Year selection.

There's a way to add also the Day_Surgery on this formula? Means that based on the Day selection , the Day_Surgery is selected?

Thank you

Re: Formula Syntax

sunny_talwar — Tue, 13 Mar 2018 14:34:10 GMT

May be try this

=Sum({<Month_Surgery = p(Month), Year_Surgery = p(Year), Day_Surgery = p(Day), Day, Year, Month, Quarter>}WI_EUR)/1000

Re: Formula Syntax

Digvijay_Singh — Tue, 13 Mar 2018 14:36:22 GMT

Do you have Day_Surgery field? if Yes, what problem you are facing if you are adding it the way you have added Month and Year? More info will help to understand the real issue.