data model

[Chanty4u]

hi all,

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

i hve below qvds ..

please help me on this..

[Chanty4u]

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

how can i achieve.

?

[simondachstr]

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

[jagan]

Hi,

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

Regards,

Jagan.

[Chanty4u]

thanks jagan.

can u shre the expression for that

[Chanty4u]

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]

Hi Suresh,

Check this link to handle the Above() in script

The As-Of Table

Hope this helps you.

Regards,

Jagan.

[Chanty4u]

thanks jagan,

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

Thanks in advance.

[jagan]

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

Regards,

jagan.

[Chanty4u]

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

thanks

[Chanty4u]

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