topic Remove hyphen from barchart in QlikView

Remove hyphen from barchart

Anonymous — Tue, 25 Jul 2017 09:48:41 GMT

Hi All,

Here, am getting a hyphen(-) in the bar chart where it should display the name of current month i.e. july.

I can't even apply the filter over there.

load Scrpit:

[PROBLEM_MANAGEMENT_OPENMONTH]:

LOAD MonthName(YEAR_OPEN_DATE,IterNo()-1) as OpenMonth,

PROBLEM_TICKET_OPENDATE,

PROBLEM_TICKET

Resident PROBLEM_MANAGEMENT_ACTIONS

While MonthName(YEAR_OPEN_DATE,IterNo()-1) < MonthName(PROBLEM_TICKET_CLOSEDATE) ;

The expression am using is :

count({< PROBLEM_TICKET_OPENDATE={'>$(=AddMonths(Max(PROBLEM_TICKET_OPENDATE),-60))'}>} DISTINCT PROBLEM_TICKET)

PrashantSangle — Tue, 25 Jul 2017 11:54:08 GMT

in chart property -> dimesion -> tick supress when value is null

Regards,

Prashant

sunny_talwar — Tue, 25 Jul 2017 11:59:07 GMT

All you need to do is to check 'Suppress When Value Is Null' for your Open Month dimension on the dimension tab

arvind_patil — Tue, 25 Jul 2017 12:10:30 GMT

HI Mahendra,

Check 'Suppress When Value Is Null' in Dimension Property.

Thanks,

Arvind Patil