Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

How to replace hyphen or ' - ' with 'No Data' in a Pivot Table?

Hi all,

I have the following example:

How do I replace the Dashes with 'No Data' instead?

I tried this as a Measure but it does not work: If(Num(Sum(LineSalesAmount), '$##,###.00')=Null(), 'No Data', Num(Sum(LineSalesAmount), '$##,###.00'))

12 Replies
miguelbraga
Specialist III
Specialist III

Try this please:

=If(IsNull(Num(Sum(LineSalesAmount))), 'No Data', Num(Sum(LineSalesAmount), '$##,###.00'))


If you make some change in your script it will make you easier to understand the expression like this:

[YourTable]:

LOAD     *,

            Num(Sum(LineSalesAmount)) as TotalNumSales

FROM [yourconnection];

By using TotalNumSales you can make the expression in pivot table like this:

=If(IsNull(TotalNumSales), 'No Data', TotalNumSales)

Hope this helps you

Regards,

MB

TKendrick20
Partner - Specialist
Partner - Specialist

If(IsNull(Sum(LineSalesAmount)),'No Data',Num(Sum(LineSalesAmount), '$##,###.00'))

yadhunandhanan
Partner - Contributor III
Partner - Contributor III

Hi John,

In Pivot table Presentation tab have two field "Null Symbol" and "Missing Symbol", just change there what you what to show in null field or missing field.

Not applicable

Hi Yadhunandhanan,

Your solution works for Qlik Sense , If yes, where that option comes ?

yadhunandhanan
Partner - Contributor III
Partner - Contributor III

Hi Rohit,

Sorry Rohit. My solution is not for Qlik Sense. Its for QlikView. 

jumuravchik
Contributor II
Contributor II

Does anybody know what the solution is for Qlik Sense?

eng19872
Creator
Creator

Is there any solution ? I am also looking for the same solution to replace hyphen with 0 or 'No Data'.

Madhab77
Contributor III
Contributor III

Hi,

Did you get any solution for this? I also facing the same issue, and need the solution.

Thanks

Madhab

eng19872
Creator
Creator

Yes, I resolved. Here is the solution

If(write your expression, true, ' ')