Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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().