Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

When using RowNo() null rows are shown

Hi There,

In my pivot chart I'd like to change the text of a cell if it is the first row in the section.

= if(RowNo() = 1, 'Row 1 Here')

This works however...

If I use RowNo() in my pivot chart it no longer hides null rows that it normally would. i.e. Rows that would normally be hidden by the expression.

Has anyone else had this problem?

Please see attached....

Thanks

1 Reply

Re: When using RowNo() null rows are shown

Hi,

Your Script is correct = if(RowNo() = 1, 'Row 1 Here')

but for Rowno( ) = 1 only if you put = if(RowNo() = 2, 'Row 2 Here') it works for rowno 2 only

what is your requirement for rowno( ) in this type of chart let me know.

HTH

Regards,

Anand

Community Browser