Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'))
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
If(IsNull(Sum(LineSalesAmount)),'No Data',Num(Sum(LineSalesAmount), '$##,###.00'))
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.
Hi Yadhunandhanan,
Your solution works for Qlik Sense , If yes, where that option comes ?
Hi Rohit,
Sorry Rohit. My solution is not for Qlik Sense. Its for QlikView.
Does anybody know what the solution is for Qlik Sense?
Is there any solution ? I am also looking for the same solution to replace hyphen with 0 or 'No Data'.
Hi,
Did you get any solution for this? I also facing the same issue, and need the solution.
Thanks
Madhab
Yes, I resolved. Here is the solution
If(write your expression, true, ' ')