Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table below:
Column dimension: if(flag=0, 'local', 'XB')
Row dimension: time_bucket
Expression:
1. count(id)
2. count(id) / count(total <flag> id)
What I want to show:
How ever now it's not working, it's showing percentage as over 500 instead of 100 or 400.
Any thoughts?
By the way, this expression works if the dimension is not a calculated one. Tested. So weird.
Due to Total it may behavior. Try to remove that and check
2. count(id) / count({<flag>} id)
This gives me 100% for all cells.
Would it possible to share sample and expected result. That would be more helpful
It's weird. I tried this expression in both QlikView and Qlik Sense. It works fine in QlikView but not in Sense.