Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Conditional background using if statement; want to ignore selections?

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

4 Replies
maneshkhottcpl
Contributor III

Conditional background using if statement; want to ignore selections?

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

Not applicable

Conditional background using if statement; want to ignore selections?

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

maneshkhottcpl
Contributor III

Conditional background using if statement; want to ignore selections?

Hi Ok but u can send me a scrambled data.

or sample application with few data.

Or explain more about the situation.

Not applicable

Conditional background using if statement; want to ignore selections?

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

Community Browser