Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

psankepalli
Contributor III

Straight Table Custom style Stripes

Experts,

I am having some design issue with the straight table.

I am using custom style stripes for my straight table to show every even row in gray and add row in White color. Now my problem is when even I add new dimension or expression this stripes feature is not applying to the newly added field.

someone please help.

I tried work around solution, sometimes that is working and sometimes not. I want straight solution for that. Am i missing anything here?

Thanks

Kesav

1 Solution

Accepted Solutions
psankepalli
Contributor III

Re: Straight Table Custom style Stripes

Thank you for everyone's reply. special thanks to rwunderlich

I followed everyone's suggestions and finally able to solve my issues.

These are the steps which I followed.

         1. Add new dimension or Expression to straight table         

          2. Go to chart Properties -> Style change Current style from Custom to Light and select stripes for every 1 row.

    • Make sure Cell Borders Transparency is 100%

          3. Click Apply and OK    

          4. Right click on the field header and go to Custom Format Cell ( To see custom format cell enable QV -> View -> Design Grid)    

          5. Change the colors as below

Back ground color: RGB(230,230,230)



Thanks

KR


10 Replies
psankepalli
Contributor III

Re: Straight Table Custom style Stripes

Any help from nay one?

Re: Straight Table Custom style Stripes

Can you post the expression you are using to set the background colour.

Digvijay_Singh
Honored Contributor III

Re: Straight Table Custom style Stripes

I was trying in attached qvw, its working for newly added dim and exp as well, I am having QV12.

Re: Straight Table Custom style Stripes

I cannot see any attachment , it may be held for moderation. Can you just post the expression.

psankepalli
Contributor III

Re: Straight Table Custom style Stripes

But for the existing straight table there nothing explicitly mentioned as back ground color. its using as Custom style and Strip rows is "1".

When I try to add new dimension or expression that particular column doesn't have any stripes.

to achieve this I am using workaround solution.

The workaround solution  I was using as background color is

=IF(Even(RowNo()),RGB(245,245,245),White())

I am not ready to use this work around. I want to use the existing cutom style but not sure how to use that and where to find that Custom style.

Please help!

Thanks

KR

psankepalli
Contributor III

Re: Straight Table Custom style Stripes

BTW.. I am using Qlikview version : QV 11.20 SR9

Re: Straight Table Custom style Stripes

Are the stripes showing correctly if you use one of the "Pyjama" styles when you change dimensions or expression?

The style is not pretty but may indicate if the error is in your custom style or elsewhere.

pyjama.JPG

Re: Straight Table Custom style Stripes

Try changing the style type from Custom to Light.

-Rob

Digvijay_Singh
Honored Contributor III

Re: Straight Table Custom style Stripes

I think expression is not making difference. I just kept Styling mode 'advanced' and color scheme as Custom in document properties and having 'light' in current style of Straight table. Its working fine for me.

Capture1.JPG

Capture2.JPG

Capture.JPG

Community Browser