Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

data model

hi all,

am new to qliksense...i hve qvd's i need to build datamodel.

i hve below qvds ..

please help me on this..

29 Replies
Chanty4u
MVP
MVP
Author

thnaks alot andy...but in pivot table i need to caluculate the cummulative and  %  of that three?

how can i achieve.

?

simondachstr
Luminary Alumni
Luminary Alumni

Hire a Qlik (View) Developer, he will do it for you!

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try Above() or Before() for accumulation, it works in QV but not sure in sense .

Regards,

Jagan.

Chanty4u
MVP
MVP
Author

thanks jagan.

can u shre the expression for that

Chanty4u
MVP
MVP
Author

Hi jagan,

I have done on that pivot table using above fun but am nt getting exact values..

please find the attached qvf file and  please update if anythng am wrong....for exact values please chk image

thanks in advance.

suresh

jagan
Luminary Alumni
Luminary Alumni

Hi Suresh,

Check this link to handle the Above() in script

The As-Of Table

Hope this helps you.

Regards,

Jagan.

Chanty4u
MVP
MVP
Author

thanks jagan,

but i dnt want caluculation in script. but i want accumulations in pivot table

Thanks in advance.

jagan
Luminary Alumni
Luminary Alumni

Handling in script as shown in that Document is very easier as compared to using Above().

Regards,

jagan.

Chanty4u
MVP
MVP
Author

but the requrmnt is nt to use in script level.....need acumalation sum of the weekly and plan and fcst...

thanks

Chanty4u
MVP
MVP
Author

hi jagan,

below the exp howng wrng values could please corrrec the exp for  Plan% complete

(AGGR(sum(PLANNEDUNITS),WeekEndDate)/sum(total PLANNEDUNITS))*100

thanks

suresh