How to create dimension to show the range

[#1]

Hello Everyone,

I have below scenario:

I have attendee count and expenses, both are measures.

I need to create a chart having range as a dimension, means from 0-10 attendees what is the sum(expenses), for 10-20 what is the sum like that till 90-100.

in x axis i need to show 0-10 to 90-100 values, this one i need to calculate from count

any suggestions please

Thanks in advance

Regards,

Sreeharsha V

[jagadeesh_diamo]

Can you post the sample data?

Create ranges and use interval match.

[its_anandrjs]

Use Class function for this.

Regards

Anand

[Anonymous]

Hi Sreeharsha

Try adding two variables for ex:lowest=0,heighest=10

and add a caliculated dimension by using if condition

Regards

Harsha

[arulsettu]

try this

class(attendees,10) in dimension

[#6]

Hello Jagadeesh,

Please find the attached excel with sample data, and i also created a sample chart how i am expecting in Qlikview

Thanks

[its_anandrjs]

You can write like

Let vX = 10;

Dimension:-  Class(attendees,vX)

Expression:- sum(expenses)

Regards

Anand

[#8]

Hello All,

Thanks for all responses, I used class function but not working as expected

Can any body please look into the sample data, and help me,

Thanks

[jagadeesh_diamo]

As suggested by our friends, you can use class function. I am unable to open your excel as i need it in XLS format.

[arulsettu]

hi find the attachment