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
Anonymous
Not applicable

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
MVP
MVP
Author

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
Not applicable

It seems something wrong with your Rangesum() expression.

Pls share.

Chanty4u
MVP
MVP
Author

Please correct it.

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

thanks

jagan
Luminary Alumni
Luminary Alumni

Hi Suresh,

Try this expression, this is similar to Relative option.

=sum(PLANNEDUNITS)/sum(total PLANNEDUNITS)


Regards,

Jagan.

Anonymous
Not applicable

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
MVP
MVP
Author

yes it is nt wrkng

Chanty4u
MVP
MVP
Author

PFA

i need to change the accumalations on pivot table and

bar chart y axis values

Anonymous
Not applicable

Oops, unfortunately dont have QS on my desktop.

Chanty4u
MVP
MVP
Author

unfrtunatly we are wrkng both QV and Qs...

PFA