topic Re: unable to execute set analysis date wise in QlikView

unable to execute set analysis date wise

Thu, 08 Jun 2017 06:39:55 GMT

Dear All,

facing problem of using set analysis

we are created variables as below

CCR_PPC :

=sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPPC'}, VC.Period=P(VC.Period) >} Quantity )

CCR_PSC :

=sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPSC'}, VC.Period=P(VC.Period) >} Quantity )

When we are using above result in pivot table with expression as below

if(match(PCSNO,7,8,9)<>0 and Plant_Code=2300,if(Material_Code_Product='PPC',CCR_PPC,if(Material_Code_Product='PSC',CCR_PSC,0)))

then its giving result value of the month not day wise.

Re: unable to execute set analysis date wise

tajmohamed30 — Thu, 08 Jun 2017 07:36:42 GMT

You can use Day(Date_Column) in your expression

Re: unable to execute set analysis date wise

Peter_Cammaert — Thu, 08 Jun 2017 09:32:31 GMT

I guess your variable formulas are being calculated at the wrong moment. Maybe you should remove the equal signs from your variable formulas, and use $-sign expansion in your actual expression. Like:

CCR_PPC :

sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPPC'}, VC.Period=P(VC.Period) >} Quantity )

CCR_PSC :

sum( { $ <Plant_Code= {'2300'}, Product_Type={1}, Material_Code={'CCRPSC'}, VC.Period=P(VC.Period) >} Quantity )

Pivot table formula:

if( match(PCSNO,7,8,9)<>0 and Plant_Code=2300,

if(Material_Code_Product='PPC', $(CCR_PPC), if (Material_Code_Product='PSC', $(CCR_PSC), 0)))

Best,

Peter

Re: unable to execute set analysis date wise

Thu, 08 Jun 2017 10:04:47 GMT

Dear All,

Thanks for your response

There was some other problem in my pivot table dimensions. the same has corrected now.

Please ignore the discussion.