p() function for multiple fields in qlikview

[lprasanth]

Hi guys,

How can I write the following function

sum({<encours_date_forescast=P(data22,data23,data24,data25,data26,data27,data28
>}encours_qte_forescast * $(vfilter5bis)),0)

btw data22=only({<idDateStkP={1}>}[date stock projection]) 

                                 .

                                 .

         data28=only({<idDateStkP={8}>}[date stock projection]) 

pls help me out on this one

[pradosh_thakur]

is data22 .. data28 variable?

if yes then  try this

sum({<encours_date_forescast={$(data22),$(data23),$(data24),$(data25),$(data26),$(data27),$(data28)}
>}encours_qte_forescast * $(vfilter5bis))

why is ,0) is there in your expression btw?

[lprasanth]

Hi pradosh,

   those are if conditions, not the variable, this is how it look like

if(idDateStkP='1',[date stock projection]) as data21,

[pradosh_thakur]

but you have mentione data22 to data 28 as only function?

can you tell me what you want to achieve logically, it will be easier to provide a solution.

[sunny_talwar]

May be it will help if you are able to provide few rows of data and explain what you are trying to get out of it