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

Calculated Dimension Value

Need to create a chart where Region values are America, Europe and Asia but the requirement is to show another value which is the sum of all three as Overall. Any suggestions ?
Would be it be better to solve it in the script or the object level ?

Regions.png

1 Solution

Accepted Solutions
NareshGuntur
Partner - Specialist
Partner - Specialist

Hi,

Please find the attached QVW.

Best Regards,

Naresh

View solution in original post

8 Replies
Nicole-Smith

Not applicable
Author

Hi,

Either way is fine.But at chart level it's fine with simple aggregation sum({Field<{Regions}>}Field).Rename the label as Overall

can use set analysis for the same.

Thanks.

Anonymous
Not applicable
Author

Current expression is Sum(Sales) with Dimensions as Region and Industry.

Couldn't understand your example above.

sebastiandperei
Specialist
Specialist

Hi.

You can use Calculated Dimention like:

If (Match(Region,'America','Europe','Asia')>0, Region, 'Overall')

suresh_rawat
Creator II
Creator II

Hi Arsalan,

For getting total with all the dimensions.

Go to Dimension Limits, refer the image attached below(Total.png).

Then on Expression - > Background Color - > =if(Region=Region,rgb(80,160,240),rgb(252,115,98)).

Kindly refer the attached image, I have disabled the Dimension Name but with blue color shows region(like america, india etc) and red color shows(total_d).

Regards

Suresh Rawat

suresh_rawat
Creator II
Creator II

Hi Arsalan,

Kindly refer the attached QVW file.

Here you'll find the solution of your requirement.


Also follow the steps defined in previous post of mine, to made this chart.

Hope this will help you to get the desired result.

Regards

Suresh Rawat

NareshGuntur
Partner - Specialist
Partner - Specialist

Hi,

Please find the attached QVW.

Best Regards,

Naresh

Not applicable
Author

Hi Arsalan,

sorry,I got your query wrong first.


Please find the snapshot.