Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mahendra6605
New Contributor II

Remove hyphen from barchart

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.

qlikview.png

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)


3 Replies

Re: Remove hyphen from barchart

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

Regards,

Prashant

Regards,
Prashant Sangle

Re: Remove hyphen from barchart

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

arvind_patil
Valued Contributor II

Re: Remove hyphen from barchart

HI Mahendra,

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


Thanks,

Arvind Patil

Community Browser