Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
arsalanam
Creator
Creator

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
Partner

Hi,

Please find the attached QVW.

Best Regards,

Naresh

View solution in original post

8 Replies
Nicole-Smith

Not applicable

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.

arsalanam
Creator
Creator
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
Partner

Hi,

Please find the attached QVW.

Best Regards,

Naresh

View solution in original post

Not applicable

Hi Arsalan,

sorry,I got your query wrong first.


Please find the snapshot.