Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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