topic Conditional background using if statement; want to ignore selections? in QlikView

Conditional background using if statement; want to ignore selections?

Tue, 14 Dec 2010 11:36:10 GMT

Hi All

I have a table whose expressions have set analysis to ignore any selections in a field called period, like :

Sum({$<Period=>} Actuals)

I have a conditional formatting function for the background of this like:

[CODE]if([4AN - Level 4 Account Name]='Income',RGB(199, 250, 254),if([4AN - Level 4 Account Name]='Non Pay Costs',RGB(255, 202, 202),if([4AN - Level 4 Account Name]='Pay Costs',RGB(185, 255, 185),RGB(205, 201, 201)))) [/CODE]

The problem I'm having is when people are selecting in Period the expression is giving the same result but the conditional formatting is changing? E.g. it will be showing the income colour, make a selection in period it shows (for some entries) the colour of the default, that is the last RGB value in the nested if?

Please can anyone advide on how to get this to work please?

Thanks

Dominic

Conditional background using if statement; want to ignore selections?

maneshkhottcpl — Tue, 14 Dec 2010 11:43:19 GMT

Hi, If u send me the application , i can surly help u.

Conditional background using if statement; want to ignore selections?

Tue, 14 Dec 2010 11:48:02 GMT

Sorry, it contains confidential info; however I can help with any questions you need answering?

Conditional background using if statement; want to ignore selections?

maneshkhottcpl — Tue, 14 Dec 2010 11:52:05 GMT

Hi Ok but u can send me a scrambled data.

or sample application with few data.

Or explain more about the situation.

Conditional background using if statement; want to ignore selections?

Tue, 14 Dec 2010 12:13:59 GMT

This demonstrates the problem; when you select an entry from F1 the conditional formatting changes. Thanks.