topic Re: Data Against Unselected Values in Chart in QlikView

Data Against Unselected Values in Chart

Anonymous — Tue, 20 Mar 2012 06:37:46 GMT

Dear All,

I have a Requirement where

i have data in this format

and output of chart is

If a User Selects Jan

then we get Data in this Format

But i want Data in

Please Help me ASAP

Please Help me out

CELAMBARASAN — Tue, 20 Mar 2012 06:53:28 GMT

Hi,

Use pivot table and drag the month dimension to horizontal

Month and Country should be dimension

Sum(Amount) should be expression.

Celambarasan

Anonymous — Tue, 20 Mar 2012 07:10:35 GMT

Dear Celambarasan

But if a User Selects Jan Month then Chart Get Reduced to

But i want

CELAMBARASAN — Tue, 20 Mar 2012 07:14:06 GMT

Hi,

Chart properties-->Presentation tab-->Uncheck the suppress zero values option.

ChartProperties-->Dimension-->Show all values

Celambarasan

Anonymous — Tue, 20 Mar 2012 07:23:47 GMT

Thnxs a Ton

Celambarasan