topic Conditional formatting a straight table in QlikView

Conditional formatting a straight table

Mon, 24 Apr 2017 22:42:11 GMT

Hello dear community,

I have a problem with the formatting of the straight table.

When i make a selection in the org field or any other field, the formatting and the subtotal dissapear from the straight table. The formatting is based on the collumn Format1 with a flag c to indicate subtotal lines.

Any help would be appreciated on how i could keep the formatting and the subtotal and yet keep the selection interactive?

Thanks in advance for your help!!

Re: Conditional formatting a straight table

prachisangewar — Tue, 25 Apr 2017 06:55:06 GMT

hi,

In the Set Analysis you are taking in values only for Org = 'OC', then why do you want to select the filter for Org.

Also the ORG value for all Values having Format1 = c are "NULL", so if you make any selection on ORG the NULL values will be excluded by default.

Re: Conditional formatting a straight table

Tue, 25 Apr 2017 07:50:42 GMT

Hi Prachi,

The filter Org was an example, yu can take any other filter Analytique for example.

You are right about the second point, as Org and Format1 are ot in the same table, is there any other solution, so that the Format1=c stays inspite of selections?

Thank you