topic Re: Add a row no field to a straight table in QlikView

Add a row no field to a straight table

mayuranp — Thu, 28 Dec 2017 13:54:47 GMT

I have a straight table in my qlikview app. I want to warn the users before exporting the table as it can contain a lot of records. Dimensions in this table is not fixed and the users can select the fields to appear in this table.

Ideally, I want to display the no of records in the table caption. From what I read, I think this is not possible.

As a workaround, I would like to add a field that has the row numbers. Is this possible? I tried Rank() and RowNo() functions with no luck.

Any suggestions?

Thanks.

Re: Add a row no field to a straight table

pradosh_thakur — Thu, 28 Dec 2017 13:56:19 GMT

try

rowno(total)

Re: Add a row no field to a straight table

mayuranp — Thu, 28 Dec 2017 14:01:22 GMT

I have seen this in many places in qlik community and it is returning always 1.

Re: Add a row no field to a straight table

pradosh_thakur — Thu, 28 Dec 2017 14:37:50 GMT

my bad .. i understood you wanted it in rows can you try count (distinct dim1,dim2...) add your dimension here.

regards

Pradosh

Re: Add a row no field to a straight table

mayuranp — Thu, 28 Dec 2017 14:40:13 GMT

Dimensions in the table can vary as per user selection.

Re: Add a row no field to a straight table

marcus_sommer — Thu, 28 Dec 2017 15:33:25 GMT

You mean the user has a listbox from which multiple dimensions could be chosen? Then you could use something like this:

count(distinct $(=concat('[' & YourDimensionListbox & ']', '&')))

- Marcus

Re: Add a row no field to a straight table

mayuranp — Thu, 28 Dec 2017 15:43:06 GMT

I have a list box with fields where the user can choose the dimensions to appear in the straight table. However, the list box does not have the full field names.

For example: Real Field Name is CountryName and the list box has a value 'Country' for the user to select to display CountryName field in the table.

If I cannot come up with a better solution I need to display the field names as they are in the list box and use this approach to display the no of records in the table.

Some field names are long and do not want to display as they are.

Re: Add a row no field to a straight table

marcus_sommer — Thu, 28 Dec 2017 16:08:33 GMT

If your listbox-field is directly associated to the real fieldnames you could just use this field, maybe by extending the load for it, for example:

SelectDimensions:

load * inline [

YourDimensionListbox, RealFieldnames

Country, CountryName

...

];

- Marcus

Re: Add a row no field to a straight table

mayuranp — Thu, 28 Dec 2017 16:10:36 GMT

This is working nicely. I hope it is not an expensive function in Qlikview.

Thanks