topic Re: Multiple If Statements in QlikView

Multiple If Statements

Tue, 24 Feb 2015 19:38:52 GMT

I am running into trouble trying to get a count of data based on multiple if statements. This is my expression that i am currently using:

if(Num(Month(Modification_Date)=Num(Month(Today(),if(ERM_sales_cycle_stage_id='6'),count(ERM_deal_product_id),'0')

Ultimately i am looking to see a MTD count of deals that have a sales cycle id of 6.

Any help would be greatly appreciated.

Tue, 24 Feb 2015 19:46:51 GMT

Just at a quick glance it looks like you're missing parentheses, try...

=if(Num(Month(Modification_Date)=Num(Month(Today(),if(ERM_sales_cycle_stage_id='6'),count(ERM_deal_product_id),'0'))))

...if that doesn't work can you post a sample QVW?

Colin-Albert — Tue, 24 Feb 2015 19:53:54 GMT

In your load script, add a new field using the preceding load script below to add the Mod_MonthName field.

Load

monthname(Modification_Date) as Mod_MonthName,

* ;

Load // This is the existing Load command...

xxx as Modification_Date,

Then you can use this expression in your chart.

count( {< Mod_MonthName={'$(= MonthName(Today()) )'},

ERM_sales_cycle_stage_id={6}

>} ERM_deal_product_id )

Wed, 25 Feb 2015 08:01:42 GMT

Post you QVW file, its most likely you are missing some parenthesis

mukesh24 — Wed, 25 Feb 2015 09:04:50 GMT

Hi,

count(if(Num(Month(Modification_Date)=Num(Month(Today())) and ERM_sales_cycle_stage_id='6',ERM_deal_product_id)))

Anonymous — Wed, 25 Feb 2015 09:16:24 GMT

Hi Patrick,

Couple of closing parenthesis are missing and need to use 'and' operator to use multiple conditions:

Try:

=if(Num(Month(Modification_Date))=Num(Month(Today())) and ERM_sales_cycle_stage_id='6',count(ERM_deal_product_id),'0')

Regards

Neetha