Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
MVP
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
MVP
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