topic Group By Issue in Null Field in QlikView

Group By Issue in Null Field

vanderson009 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have data like attachment,

I have null sales value for month of Sep, because of some requirement i have taken that table as resident with group by.

But whenever i am showing this data on sheet level in table format then this null values gets replaced with "0".

I want to show that null value as "-".

Regards,

Villyee

trdandamudi — Fri, 02 Sep 2016 04:56:39 GMT

May be as below:

Anil_Babu_Samineni — Fri, 02 Sep 2016 05:55:47 GMT

Try from presentation tab

Chanty4u — Fri, 02 Sep 2016 06:01:46 GMT

try in script,

NULLASVALUE SaleMonth;

SET NullValue = '- ';

sunny_talwar — Fri, 02 Sep 2016 11:42:20 GMT

Try this script:

Test:

Load * inline [

Date,SaleMonth,SaleYear,Sales

01/23/2014,Jan,2014,20

11/11/2014,Nov,2014,0

12/24/2015,Dec,2015,50

09/19/2015,Sep,2015,

];

Final:

NoConcatenate

LOAD If(Avg(Sales) >= 0, Sum(Sales)) as Sales,

Date,

SaleMonth,

SaleYear

Resident Test

Group By Date, SaleMonth, SaleYear;

Drop Table Test;

UPDATE: Forgot to acknowledge, but I used the sample provided by Thirumala and made some modifications to it