topic Re: Calculated Dimension Value in QlikView

Calculated Dimension Value

Anonymous — Mon, 30 Dec 2013 19:19:45 GMT

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 ?

Re: Calculated Dimension Value

Nicole-Smith — Mon, 30 Dec 2013 19:25:24 GMT

Re: Calculated Dimension Value

Mon, 30 Dec 2013 19:38:03 GMT

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.

Re: Calculated Dimension Value

Anonymous — Mon, 30 Dec 2013 21:51:02 GMT

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

Couldn't understand your example above.

Re: Calculated Dimension Value

sebastiandperei — Tue, 31 Dec 2013 02:59:11 GMT

Hi.

You can use Calculated Dimention like:

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

Re: Calculated Dimension Value

suresh_rawat — Tue, 31 Dec 2013 04:44:03 GMT

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

Re: Calculated Dimension Value

suresh_rawat — Tue, 31 Dec 2013 04:57:55 GMT

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

Re: Calculated Dimension Value

NareshGuntur — Tue, 31 Dec 2013 06:56:40 GMT

Hi,

Please find the attached QVW.

Best Regards,

Naresh

Re: Re: Calculated Dimension Value

Tue, 31 Dec 2013 07:36:40 GMT

Hi Arsalan,

sorry,I got your query wrong first.

Please find the snapshot.