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..

[Anonymous]

What is the Dimension you are using for this expression:

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

if no such dimension then try:

=(sum(PLANNEDUNITS)/sum(Total PLANNEDUNITS))*100

[Chanty4u]

thanks.

but it is nt wrkng ..rangesum is wrkng  for rangesum.....

and i need to show bar chart for y axis 0 to 100%... but is shwng  for me a 0 to 20%.?

what can i do ?any idea

thanks

[Anonymous]

It seems something wrong with your Rangesum() expression.

Pls share.

[Chanty4u]

Please correct it.

(RangeSum(sum(PLANNEDUNITS))/sum(total PLANNEDUNITS))

thanks

[jagan]

Hi Suresh,

Try this expression, this is similar to Relative option.

=sum(PLANNEDUNITS)/sum(total PLANNEDUNITS)

Regards,

Jagan.

[Anonymous]

Jagan,

Already shared this expression with him, but strange its not working for him.

and putting rangesum() like

(RangeSum(sum(PLANNEDUNITS))/sum(total PLANNEDUNITS)), dont think it is the right use of it.

Suresh,

Post your sample app.

[Chanty4u]

yes it is nt wrkng

[Chanty4u]

PFA

i need to change the accumalations on pivot table and

bar chart y axis values

[Anonymous]

Oops, unfortunately dont have QS on my desktop.

[Chanty4u]

unfrtunatly we are wrkng both QV and Qs...

PFA