Want to have a block chart in two colors only

[immkhan2]

Hi Gurus,

I am new to Qlik view and I am developing a Warehouse KPI. I want to show the BIN position as Empty or Full. I have multiple Bins in an Aile, so I have to represent it as Empty or Full.

I am making a Block Chart and couldn't able to represent it in only two colors. My data is :

LOAD * INLINE [

    F1, F2

    A11A, 1

    A11B, 0

    A12A, 1

    A12B, 1

    A13A, 0

    A13B, 0

    A14A, 1

    A14B, 0

];

Need advice.

Regards

Imran

[Gysbert_Wassenaar]

Don't use F2 as expression. Zero values will mean a surface areas of zero. In other words areas that can't be shown. Use 1 as area size:

LOAD *, 1 as AreaSize INLINE [

    F1, F2

    A11A, 1

    A11B, 0

    A12A, 1

    A12B, 1

    A13A, 0

    A13B, 0

    A14A, 1

    A14B, 0

];

Then in your block chart use F1 and F2 as dimensions and sum(AreaSize) as expression.

[raajaswin]

This is what you want??

[immkhan2]

Yup and gysbert reply fulfilled my requirement.

[raajaswin]

You can directly give 1 in your expression instead of inline also.

In expression just give 1 instead of F2