topic Re: How to replace the value 0 value with text in QlikView

How to replace the value 0 value with text

Karim_Khan — Tue, 15 Sep 2015 12:16:51 GMT

Hi Team,

I am trying to replace the zero (0) value with Text ( No.Of Booking 2015).

I am getting some value as 0 in the column of Monthly YOY and Copy of YOY I want to replace this values by No.Of bookings 2015.

Regards,

MRKachhiaIMP‌jagan‌gwassenaar‌ashfaq_haseeb‌Kush141087‌

Re: How to replace the value 0 value with text

MK_QSL — Tue, 15 Sep 2015 14:09:34 GMT

You can have

IF(YourExpression = 0, 'YourText',YourExpression)

Re: How to replace the value 0 value with text

Kushal_Chawda — Wed, 16 Sep 2015 05:50:07 GMT

check monthly copy YOY expression

see the attached

Re: How to replace the value 0 value with text

sasiparupudi1 — Wed, 16 Sep 2015 07:31:40 GMT

please see the attached file

Re: How to replace the value 0 value with text

Karim_Khan — Wed, 16 Sep 2015 13:22:23 GMT

Hi Sir,

There is a minor change in the condition.Suppose if there is a 0 zero value in Monthly 2014 column then it should show 'No FY Booking 2014' in Monthly Copy YOY cloumn.and if there is a 0 zero value in Monthly 2015 column then it should show 'No FY Booking 2015' in Monthly Copy YOY

I am trying to create the scenario with below expression

=if(v2014=0,'No FY Booking 2014' or v2015=0,'No FY Booking 2015',([Monthly 2015]/[Monthly 2014])-1))

Variable store value

v2014='$' & round(num(sum({$<[Fiscal Year] = {'2014'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))

v2015='$' & round(num(sum({$<[Fiscal Year] = {'2015'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))

Regards,

Re: How to replace the value 0 value with text

Karim_Khan — Wed, 16 Sep 2015 13:40:28 GMT

There is a condition.Suppose if there is a 0 zero value in Monthly 2014 column then it should show 'No FY Booking 2014' in Monthly Copy YOY cloumn.and if there is a 0 zero value in Monthly 2015 column then it should show 'No FY Booking 2015' in Monthly Copy YOY

I am trying to create the scenario with below expression

=if(v2014=0,'No FY Booking 2014' or v2015=0,'No FY Booking 2015',([Monthly 2015]/[Monthly 2014])-1))

Variable store value

v2014='$' & round(num(sum({$<[Fiscal Year] = {'2014'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))

v2015='$' & round(num(sum({$<[Fiscal Year] = {'2015'},[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00'))