topic Re: If condition with two set expressions in QlikView

If condition with two set expressions

gopinadhpindra — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlikexperts,

Below If condition with multiple set expression is not displaying the value.

Scenario:

TerritoryDesc=Alpha -->it need to execute the First Set Expression ,or Else Statement.

IF Statement with multiple Set Expression:

if(TerritoryDesc='Alpha',sum({$<Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Calendar_Half_Year_Eng={'Jul-Dec'},BusinessArea=P(BU),Calendar_Month = {'<=$(=max(Calendar_Month))'},Day_of_Week=,CP_Team_Flag = {'CP','ORG'},Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000,

sum({$<Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Month={'*'},Calendar_Month = {'<=$(=max(Calendar_Month))'},Day_of_Week=,CP_Team_Flag = {'CP','ORG'},Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000)--->End of IF Statement

Even tried with Variable :

if(SAP_TerritoryDesc='Kottayam',Vsup,Vex)

stalwar1‌marcowedel‌dilipranjith‌sagupta2792‌maxgro‌

Re: If condition with two set expressions

sunny_talwar — Mon, 05 Nov 2018 12:04:28 GMT

Is this used in a chart where you have TerritoryDesc as dimension? Also, does this show anything if no selections are made?

Re: If condition with two set expressions

dplr-rn — Mon, 05 Nov 2018 13:44:56 GMT

1 mistake detected. replace ' by " double quotes in date set analysis

Calendar_Month = {"<=$(=max(Calendar_Month))"}

single quotes are for literal matches i.e. equal to something definte

also is star a value below? if not same change

Month={'*'}

Re: If condition with two set expressions

gopinadhpindra — Mon, 05 Nov 2018 15:06:32 GMT

Here we are using straight tablee month and product is the dimension,condition enabling also there

Actually I need Q3 onwards(July to dec) sales value make it as 0 because territory desc=alpha merze with some other territory so there is no salesvalue for July onwards

Vsup:variable

The above exp showing sales value for all months

Vex:variable

sum({$<Version_Desc = {'Adjustment','Actual'},SalesType_Key={'1'},SalesPeriod = {1},Calendar_Half_Year_Eng={'Jul-Dec'},BusinessArea=P(BU),Calendar_Month = {'<=$(=max(Calendar_Month))'},Day_of_Week=,CP_Team_Flag = {'CP','ORG'},Product_Group_Code -= {'ENCG','ENTG'}>}Sales_Value)/1000

The above exp limit the July to Dec sales value 0

if(TerritoryDesc='alpha',Vsup,Vex)

That what I need these both into if condition

Any ideas or any other way to write the expression

Sunny plz help me on this

Thanks

Re: If condition with two set expressions

gopinadhpindra — Mon, 05 Nov 2018 15:08:16 GMT

Hi dilip,

That not an issue here,that exp working fine only

Re: If condition with two set expressions

wade12 — Mon, 05 Nov 2018 15:08:24 GMT

your issue may be here:

BusinessArea=P(BU)

Re: If condition with two set expressions

gopinadhpindra — Mon, 05 Nov 2018 17:05:12 GMT

I will check on this let you know

Re: If condition with two set expressions

MarcoWedel — Mon, 05 Nov 2018 19:57:25 GMT

pin var wrote:

Here we are using straight tablee month and product is the dimension,condition enabling also there

Could there be more than one distinct value of TerritoryDesc per month/product combination?

Re: If condition with two set expressions

gopinadhpindra — Tue, 06 Nov 2018 04:18:27 GMT

No Marco.....