Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need serial no in below sequence.
srno, state city sales
1 AP
2 KA
3 OD
4 TN
5 UP
Please do the needful.
I have attached source file and qlikview file.
If you are using QV12 or above, you can try this as your calculated dimension
=aggr(RowNo(), (State, (TEXT)))
If you are using QV12 or above, you can try this as your calculated dimension
=aggr(RowNo(), (State, (TEXT)))
Please can you explain why you use (TEXT) ?
Thanks
Read here Sortable Aggr function
thanks sunny it is working for my sample data but when i am trying to use this main application for some state the serial no for some state coming blank though value is present some expression. I attached screen shot of the pivot table . please check
Checked and you are right that some of the state have blank, but I don't really know what is different about your sample and your actual app? May be you can provide a sample which is more aligned with your actual app to help you.