Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
everest226
Creator III
Creator III

help with expression on sense

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] )

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

dplr-rn
Partner - Master III
Partner - Master III