Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

unable to execute set analysis date wise

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.

Untitled.jpg

3 Replies
tajmohamed30
Contributor III

Re: unable to execute set analysis date wise

You can use Day(Date_Column) in your expression

Re: unable to execute set analysis date wise

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

Not applicable

Re: unable to execute set analysis date wise

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.

Community Browser