topic Re: Addition of a row and count in caption in QlikView

Addition of a row and count in caption

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

Hello Community,

I have created a straight table with 3 dimensions and a calculated expression. I want to add another column in the beginning where it'll give me the row number which will generated dynamically.

And based on that column I want to show the count in caption.

(if i write count for the expression the number in caption and the no of records in the table are different) so I want to count the no of rows in table to show it in the caption.

I am unable to solve it on my own. Please help to resolve this issue.

Sudhir.

Sample table is this

Customer Name	Customer Address	Status
A	X	1
B	Y	0
C	Z	1
D	W	1
E	U	0
F	V	1

requirement is to add another column

S.No(dynamic calculated field for no of rows)
1
2
3
4
5
6

Re: Addition of a row and count in caption

sunny_talwar — Sat, 10 Dec 2016 12:17:18 GMT

May be create an expression RowNo(TOTAL) and then drag it to be the very first column?

Re: Addition of a row and count in caption

sudhir0538 — Sat, 10 Dec 2016 12:41:23 GMT

Hello Sunny,

the proposed solution is working fine for the column. Thnx.

How can I show the sum of rows same in caption??

i tried count but not worked

Re: Addition of a row and count in caption

sunny_talwar — Sat, 10 Dec 2016 12:43:46 GMT

Can you share what your dimensions and expressions look like?

Re: Addition of a row and count in caption

sunny_talwar — Sat, 10 Dec 2016 12:44:24 GMT

Or Assuming Customer Name to be the only dimension, you can try this

Count(DISTINCT [Customer Name])

Re: Addition of a row and count in caption

sudhir0538 — Wed, 14 Dec 2016 11:44:27 GMT

Hi, I have 4 dimensions (no calculated ones) and a expression. Where in the expression I'm showing the days different field with some set analysis condition.

I think one of the non dimension field have some distinct values,and I fed up with checking each and every field because there are lot of fields in the table. Sample will looks like this

Here I wrote the count in Caption luckily it showing 0 and there's no records today. But sometimes the captioned count is mismatched with he no of records display in the straight table.

Please do the needful to resolve the issue.

Thnx

Re: Addition of a row and count in caption

sunny_talwar — Wed, 14 Dec 2016 11:51:59 GMT

I would need to see more than just what you are telling me. Do you have a sample you can share? or put down all your dimension and expressions for me here so that I can get a feel for what you have. Also make sure to mention any other things (such as dimension limits) restricting the chart.

Re: Addition of a row and count in caption

sudhir0538 — Sat, 17 Dec 2016 04:50:40 GMT

Hello Sunny,'

I find out the column and I added it in the caption set analysis now the problem solved.

Thnx for all the help.