Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: help with expression on sense

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: help with expression on sense

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

Highlighted
Partner
Partner

Re: help with expression on sense