Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lprasanth
Contributor II
Contributor II

p() function for multiple fields in qlikview

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

Labels (2)
4 Replies
pradosh_thakur
Master II
Master II

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?

Learning never stops.
lprasanth
Contributor II
Contributor II
Author

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
Master II
Master II

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.

Learning never stops.
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