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: 
Albelugo
Contributor
Contributor

Set breakeven date in a variable

Hello Experts. I need your help.

I have a situation like described in this post:

https://community.qlik.com/t5/New-to-Qlik-Sense/Return-a-specific-Break-Even-Date-from-Table/td-p/15...

The difference is that I need to set the breakeven date (31/12/2018) in a variable, but if a use the same expression, don't Work.

Could you help me please?

Thanks a lot!!!! 

 

Labels (3)
1 Reply
marcus_sommer
MVP
MVP

The solutions from the provided link should also be working within a variable. But you shouldn't start with the variable else doing the same step by step approach like in the link. Means creating a table-chart and applying there the accumulation step by step and if this worked you may transferring it to a higher granular table by applying the aggr(). The final step is then to adjust the aggr() dimension to the needed dimensionality and/or to wrap the aggr() with another aggr().