topic Re: Need serial number in pivot table dimension in QlikView

Need serial number in pivot table dimension

tripatiqv — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Need serial number in pivot table dimension

sunny_talwar — Tue, 14 May 2019 11:43:34 GMT

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

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

Re: Need serial number in pivot table dimension

sergio0592 — Tue, 14 May 2019 14:26:01 GMT

Please can you explain why you use (TEXT) ?

Thanks

Re: Need serial number in pivot table dimension

sunny_talwar — Tue, 14 May 2019 14:40:54 GMT

Read here Sortable Aggr function

Re: Need serial number in pivot table dimension

tripatiqv — Wed, 15 May 2019 07:51:36 GMT

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

Re: Need serial number in pivot table dimension

sunny_talwar — Wed, 15 May 2019 11:09:17 GMT

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.