Chart with values different of Empty only.

[#1]

Dears, how are you?

I've jsut started using QlikView and now I would like to create a chart, with data from my Excel Spreadsheet.

The problem is that my Excel SpreadSheet has some empty values (and it is expected), but I don`t want to show this values in my QlikView Chart.

I'll give you my scenario.

The Y axes (blue) is the sum of Fuel burned

The Y axes (red) is the sum of Fuel expeted.

So I have two bars in the Y axes. (Expression)

The X axes are the date from Column Date (Dimension)

I would like to show values only if the Fuel Expected is different from empty.

How can I do it?

Thanks a lot,

Best regards,

Bruno Lelli

[maxgro · Accepted solution]

If I understand you can try to set null the date dimension

=if(aggr(sum([Fuel Expected]), Date)=0, null(), Date)

and check the Suppress when value is null

[#3]

Thanks a lot, it worked perfectly.

Now I have another doubt, I've another chart without dimension... with only two expressions...

The sum of fuel burned (red bar)

The sum of expeted fuel (blue bar)

All the cells of my excel spreadsheet has the fuel burned information, but only some cells has the expected fuel information.

So, I would like to show in my chart the sum of the fuel burned and expected only if the information is available for both items. I don't want to sum the fuel burned  if I don`t have the information of the expected fuel.

How can I do it?

Thanks a lot per your help,

Best regards,

Bruno Lelli