Need serial number in pivot table dimension

[tripatiqv]

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.

[sunny_talwar · Accepted solution]

If you are using QV12 or above, you can try this as your calculated dimension

=aggr(RowNo(), (State, (TEXT)))

 

[sergio0592]

Please can you explain why you use (TEXT) ?

Thanks

[sunny_talwar]

Read here Sortable Aggr function

[tripatiqv]

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

[sunny_talwar]

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.