topic Re: color for rows in QlikView

color for rows

kishorj1982 — Wed, 25 Oct 2017 10:15:00 GMT

Hi All,

PFA

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

Thanks

Re: color for rows

Clever_Anjos — Wed, 25 Oct 2017 10:48:14 GMT

2 ways

Go to "Style Tab" and change to Pijama Blue
Use if(Mod(Rowno(total),lightblue()) as background color expression

Re: color for rows

kishorj1982 — Wed, 25 Oct 2017 11:32:56 GMT

Hi,

Thanks

but expression is not working

thanks

Re: color for rows

sergio0592 — Wed, 25 Oct 2017 11:50:39 GMT

Hi,

Use Even() function with :

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

Re: color for rows

kishorj1982 — Wed, 25 Oct 2017 12:32:29 GMT

Hi All,

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

Thanks

Re: color for rows

Clever_Anjos — Wed, 25 Oct 2017 13:52:46 GMT

could you attach a screenshot of your expression?

Re: color for rows

kishorj1982 — Thu, 26 Oct 2017 04:05:27 GMT

Hi,

PFA.

Can you please share an example.

thanks

Re: color for rows

Anonymous — Thu, 26 Oct 2017 05:06:24 GMT

Hi,

see Attachments

i think its according to your requirement

Re: color for rows

kishorj1982 — Thu, 26 Oct 2017 05:29:53 GMT

Yes,

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

thanks

Re: color for rows

tresB — Thu, 26 Oct 2017 05:32:27 GMT

Try to share your sample qvw that shows the issue.

Re: color for rows

Clever_Anjos — Thu, 26 Oct 2017 09:35:49 GMT

I meant :could you post a screenshot of your expression background?

Re: color for rows

pradosh_thakur — Thu, 26 Oct 2017 10:06:57 GMT

setting-> user preferences-> check always show design menu items

go to the table -> propeties -> style-> strip every 1 rows

hover mouse on a cell of the table -> right click on cell -> custom format cell -> change the back ground color -> apply change to all dimension

click apply and you are done with your requirement ..

regards

Pradosh