Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community
Here's the problem i'm facing -
I have a pivot table with a column called Total customers.
Total Customers = RangeSum(above(Count({<IsInYTD={1}>}current_account_id),0,4))
My actual requirement is to show the transposed form of the table but when I do so (by just dragging the dimensions to the top and Expressions to the left), The above expression doesn't work anymore and I get all zeroes.
Can Anybody suggest a workaround.
Normal Table (Working) -
Transposed Table (Not Working) -
Attached is the reduced QVW.
Regards
-Sneh
Hi Sneh,
PFA. You have to use "Before" function.
Thanks,
Nisha
It should help
https://community.qlik.com/docs/DOC-8242
Tell me, Expected O/P
Thank you Nisha. that worked.
Thanks Anil. This helped.