Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] )
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
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