topic Re: help with expression on sense in App Development

help with expression on sense

everest226 — Tue, 21 May 2019 17:53:40 GMT

I am trying to use alternative State in sense application. i have created alternative state Group 1 . now how do i assign Group 1 to the bellow expression . so the measure is controlled .

Sum({<Is={'ALL'},[ Start Date]={">=$(vStartDateFrom)<=$(vStartDateTo)"},[ Finish Date]={">=$(vFinishFrom)<=$(vFinishTo)"} [Good Sold] )

Re: help with expression on sense

rwunderlich — Tue, 21 May 2019 18:03:45 GMT

Use the statename as the Set Identifier in the expression:

Sum({[Group 1]<Is={'ALL'},[ Start Date]={">=$(vStartDateFrom)<=$(vStartDateTo)"},[ Finish Date]={">=$(vFinishFrom)<=$(vFinishTo)"} [Good Sold] )

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: help with expression on sense

dplr-rn — Tue, 21 May 2019 18:04:08 GMT

Sum({Group1<Is=...................
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Examples%20of%20Alternate%20States%20in%20Chart%20Expressions.htm