topic Re: Row Count in QlikView

Row Count

jagjivvt — Wed, 28 Mar 2018 08:45:55 GMT

Hi,

I am using this formula RowNo(TOTAL) and this places a number which is correct, but within the data set I need the count to also check a dimension and if this is the same for a few rows then the number should remain the same.

thanks

vijay

Re: Row Count

MK_QSL — Wed, 28 Mar 2018 08:49:25 GMT

Kindly provide sample data or sample app and then explain what you want to achieve !

Re: Row Count

sunny_talwar — Wed, 28 Mar 2018 08:53:28 GMT

May be use Rank(DimensionName)... numbering might be different, but if should rank the same dimension with the same number I think

Re: Row Count

jagjivvt — Wed, 28 Mar 2018 08:56:07 GMT

Hi tried that it just puts a 1 on each row.

Re: Row Count

sunny_talwar — Wed, 28 Mar 2018 08:57:28 GMT

How about this

Rank(TOTAL DimensionName)

Re: Row Count

jagjivvt — Wed, 28 Mar 2018 09:00:28 GMT

Hi Sunny this works, thanks

Re: Row Count

jagjivvt — Wed, 28 Mar 2018 09:58:07 GMT

hi Sunny,

is it then possible to change the result to a single number so that all the ones that are same starts with 1 and then adds 1 to the next set and so on.

thanks

vijay

Re: Row Count

sunny_talwar — Wed, 28 Mar 2018 11:12:15 GMT

Not sure I understand the output you are looking to get... can you show this via an example?

Re: Row Count

jagjivvt — Wed, 28 Mar 2018 12:30:47 GMT

Hi Sunny

please see below, in column C I need the 3 to be replaced with the Rank expression starting with 1 and then any additional to add 1 to it.

thanks