Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have got scenario to calculate open days with 2 dates field.
Now I want logic -
For Notification Field value - 123, it should take maximum of Completion Date field and then it should do = (Max(completion date) - Created date))
So this is the desired output -
Could some one explain what need to be done to get the output?
This should be easy but i am new to Qlik Sense!
Thanks in advance,
try to use
sum(aggr(NODISTINCT max([Completion date]),Notification)-[Created date])
for your expression in straight table with Notification, Created date, Completion date as dimensions.
Hope it helps.
View solution in original post
Awesome! It works fine.