Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
tripatiqv
Partner - Contributor III
Partner - Contributor III

Need serial number in pivot table dimension

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.

 

 

1 Solution

Accepted Solutions
sunny_talwar

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

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

image.png 

View solution in original post

5 Replies
sunny_talwar

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

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

image.png 

sergio0592
Specialist III
Specialist III

Please can you explain why you use (TEXT) ?

Thanks

 

sunny_talwar

tripatiqv
Partner - Contributor III
Partner - Contributor III
Author

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.