topic If condition issue in QlikView

If condition issue

dineshm030 — Mon, 20 Aug 2018 07:09:59 GMT

Hi Legends,

We are facing IF condition kindly help me.

Expression:

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000

We are using above expression we get the value of DEPURA in the report.

Expression:

If(BU = 'Women Health',

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000,

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1}>}Sales_Value)/1000)

Where as We are using above expression we do not get the value of DEPURA in the report.

Re: If condition issue

arvind_patil — Mon, 20 Aug 2018 07:24:44 GMT

Hi Dinesh,

Pelase try below:

If(Wildmatch(BU, 'Women Health'),

(sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000),

(sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1}>}Sales_Value)/1000))

Thanks,

Arvind Patil

Re: If condition issue

dineshm030 — Mon, 20 Aug 2018 07:32:03 GMT

it doesn't work arvind....

Re: If condition issue

arvind_patil — Mon, 20 Aug 2018 07:58:20 GMT

Hi Dinesh,

I am sure there is Bracket issue kindly check without division.

If(BU = 'Women Health',

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1},CP_Team_Flag=,Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value),

sum({<Day_of_Week=,Version_Desc = {'Target'},SalesType_Key={'1'},SalesPeriod = {1}>}Sales_Value))

Thanks,

Arvind Patil

Re: If condition issue

dineshm030 — Mon, 20 Aug 2018 08:09:19 GMT

Again it does not work arvind......

Re: If condition issue

tresB — Mon, 20 Aug 2018 08:18:30 GMT

This could be because- BU 'Women Health' there is no sales for Depura. Could you share your app sample?