topic Re: Replace the value with conditional in QlikView

Replace the value with conditional

Karim_Khan — Wed, 16 Sep 2015 13:26:43 GMT

Hi Team,

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'))

Regards,
KK

MRKachhiaIMP‌jagan‌gwassenaar‌ashfaq_haseeb‌Kush141087‌

Re: Replace the value with conditional

MK_QSL — Wed, 16 Sep 2015 13:35:42 GMT

You can use something like below instead of v2014 and v2015

IF(round(num(sum({$<[Month in Fiscal Year] = {'$(=only([Month in Fiscal Year]))'}>} [Net Bookings]),'##.00')) = 0,'No FY Booking ' & Max([Fiscal Year]),

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

Re: Replace the value with conditional

Karim_Khan — Wed, 16 Sep 2015 13:39:49 GMT

no it is not working

It should be change on the basis of values in other column

Re: Replace the value with conditional

Kushal_Chawda — Wed, 16 Sep 2015 14:03:13 GMT

try this condition in your expression

if([Monthly 2014] =0,'No FY Booking 2014',

if([Monthly 2015]=0,'No FY Booking 2015',

if([Monthly 2014]=0 and [Monthly 2015]=0,'No FY Booking 2014 & 2015',

([Monthly 2015]/[Monthly 2014])-1)))

Re: Replace the value with conditional

Karim_Khan — Wed, 16 Sep 2015 14:30:53 GMT

Tnx bro