topic Re: p() function for multiple fields in qlikview in QlikView

p() function for multiple fields in qlikview

lprasanth — Sat, 16 Nov 2024 04:27:26 GMT

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 — Thu, 14 Feb 2019 06:50:12 GMT

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 — Thu, 14 Feb 2019 06:56:07 GMT

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 — Thu, 14 Feb 2019 07:00:16 GMT

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 — Thu, 14 Feb 2019 13:06:29 GMT

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