topic Re: How to create dimension to show the range in QlikView

How to create dimension to show the range

Thu, 04 Dec 2014 09:08:16 GMT

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

Re: How to create dimension to show the range

jagadeesh_diamo — Thu, 04 Dec 2014 09:10:05 GMT

Can you post the sample data?

Create ranges and use interval match.

Re: How to create dimension to show the range

its_anandrjs — Thu, 04 Dec 2014 09:14:45 GMT

Use Class function for this.

Regards

Anand

Re: How to create dimension to show the range

Anonymous — Thu, 04 Dec 2014 09:14:56 GMT

Hi Sreeharsha

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

and add a caliculated dimension by using if condition

Regards

Harsha

Re: How to create dimension to show the range

arulsettu — Thu, 04 Dec 2014 09:17:25 GMT

try this

class(attendees,10) in dimension

Re: Re: How to create dimension to show the range

Thu, 04 Dec 2014 09:22:12 GMT

Hello Jagadeesh,

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

Thanks

Re: How to create dimension to show the range

its_anandrjs — Thu, 04 Dec 2014 09:23:56 GMT

You can write like

Let vX = 10;

Dimension:- Class(attendees,vX)

Expression:- sum(expenses)

Regards

Anand

Re: How to create dimension to show the range

Thu, 04 Dec 2014 09:30:04 GMT

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

Re: How to create dimension to show the range

jagadeesh_diamo — Thu, 04 Dec 2014 09:33:15 GMT

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

Re: Re: How to create dimension to show the range

arulsettu — Thu, 04 Dec 2014 09:35:47 GMT

hi find the attachment

Re: How to create dimension to show the range

its_anandrjs — Thu, 04 Dec 2014 09:37:04 GMT

Try this Dim and Expre

Dim:- =Replace(Class(Attendees,10),'<= x <', '-')

Expre:- sum(expenses)

Regards

Anand

Re: How to create dimension to show the range

Thu, 04 Dec 2014 09:40:25 GMT

Thank you so much Arul,

That is wonderful,

Can you please help me if i wanna see below values on x-axis

10-20

20-30

30-50

>50

Regards,

Sreeharsha.

Re: How to create dimension to show the range

jagadeesh_diamo — Thu, 04 Dec 2014 09:41:40 GMT

I hope you are expecting it....

Re: How to create dimension to show the range

Thu, 04 Dec 2014 09:45:31 GMT

Not exactly

Like below

10-20

20-30

30-50

>50

Thanks for the immediate reply

Re: How to create dimension to show the range

arulsettu — Thu, 04 Dec 2014 09:47:33 GMT

change the calculated dimension like this

Replace(Class(Attendees,10),'<= x <', '-')

you will get exact result

and plz close this thread by marking as correct answer

thanks

Arul

Re: How to create dimension to show the range

its_anandrjs — Thu, 04 Dec 2014 09:50:50 GMT

Hi,

You can create the calculated dimension also

LOAD Attendees,

Expenses,

if(Attendees>=0 and Attendees<=10,'0-10',

if(Attendees>10 and Attendees<20,'10-20',

if(Attendees>20 and Attendees<30,'20-30',

if(Attendees>30 and Attendees<40,'30-40',

if(Attendees>40 and Attendees<50,'40-50',

if(Attendees>50 and Attendees<60,'50-60',

if(Attendees>60 and Attendees<70,'60-70',

if(Attendees>70 and Attendees<80,'70-80',

if(Attendees>80 and Attendees<90,'80-90',

if(Attendees>90 and Attendees<100,'90-100',

if(Attendees>100 and Attendees<110,'100-110',

))))))))))) asDimAttendees

FROM

[Range_Sample Data.xlsx]

(ooxml, embedded labels, table is Sheet1);

Regards

Anand

Re: Re: How to create dimension to show the range

arulsettu — Thu, 04 Dec 2014 09:53:37 GMT

find the attachment

plz close the thread

Re: How to create dimension to show the range

maleksafa — Thu, 04 Dec 2014 09:56:34 GMT

you can do that in your script using if conditions or interval match.

and you can do that from your chart using the class() function.

Re: Re: Re: How to create dimension to show the range

Thu, 04 Dec 2014 10:24:18 GMT

Hello Arul,

Thanks for the response,

But i need to show in below order also

10-20

20-30

30-50

>50

can you please check the above values, it is not in the sequence. Please check the attached excel chart for the expected value

Thanks

Re: Re: Re: Re: How to create dimension to show the range

arulsettu — Thu, 04 Dec 2014 10:34:40 GMT

like this