multiple alternate states in chart

Tue, 10 Feb 2015 14:10:24 GMT

Hi,

I have two list boxes with separate alternate states ,

but i want to use these two states in a chart ,

=Sum({1
<
[Scenario ID]={'A','A1','A2','A3','B','B1','B2','B3','C','C1','C2','C3'}
,
[Customer AR Data Scenario at YE]={'Positive Net AR'}
,
[100% Reserve Required based on Scoping]={'NO'}
>}

[Cash Receipt])

-
( if(GetSelectedCount([Customer name])>=1,Sum({[Reserve Details Chart]
<
[Scenario ID]={'A','A1','A2','A3','B','B1','B2','B3','C','C1','C2','C3'}
,
[Customer AR Data Scenario at YE]={'Positive Net AR'}
,
[100% Reserve Required based on Scoping]={'NO'}
>}

[Cash Receipt]),0))

-
( if(GetSelectedCount([GL Document Number])>=1,Sum({[KAAP reserve]
<
[Scenario ID]={'A','A1','A2','A3','B','B1','B2','B3','C','C1','C2','C3'}
,
[Customer AR Data Scenario at YE]={'Positive Net AR'}
,
[100% Reserve Required based on Scoping]={'NO'}
>}

[Cash Receipt]),0))

i wanna exclude selection from those 2 alternate states ,[Reserve Details Chart],[KAAP reserve]

topic multiple alternate states in chart in QlikView

multiple alternate states in chart