Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

color for rows

Hi All,

PFA

How to show color for alternate rows as shown in attachment in QV pivot table and straight table.

Thanks

11 Replies
Highlighted
Employee
Employee

Re: color for rows

2 ways

  1. Go to  "Style Tab" and change to Pijama Blue
  2. Use if(Mod(Rowno(total),lightblue()) as background color expression
Highlighted
Creator II
Creator II

Re: color for rows

Hi,

Thanks

but expression is not working

thanks

Highlighted
Specialist II
Specialist II

Re: color for rows

Hi,

Use Even() function with :

=If(Even(RowNo(TOTAL))=0, rgb(171,206,241), white())

Highlighted
Creator II
Creator II

Re: color for rows

Hi All,

I am not able to get the output as per attachment's screenshot.

Thanks

Highlighted
Employee
Employee

Re: color for rows

could you attach a screenshot of your expression?

Highlighted
Creator II
Creator II

Re: color for rows

Hi,

PFA.

Can you please share an example.

thanks

Highlighted
Contributor III
Contributor III

Re: color for rows

Hi,

see Attachments

i think its according to your requirement

Highlighted
Creator II
Creator II

Re: color for rows

Yes,

But in Qlikview  it is not working as shown in attached QVF file.

thanks

Highlighted
MVP
MVP

Re: color for rows

Try to share your sample qvw that shows the issue.