topic filtering and grouping the data in QlikView

filtering and grouping the data

Tue, 15 Jul 2014 08:19:40 GMT

I am very new to qlikview, currently i am facing a problem on how to filtering the data and represent them in my pie chart.

for example:

this my excel file

age
1
5
8
2
6
7
4
5

then i want create a pie chart that shows 3 groups of age which are (age <=3 , 3 < age < 5 and age >= 5 ).

the pie chart should look like this..

Re: filtering and grouping the data

mdmukramali — Tue, 15 Jul 2014 08:32:38 GMT

Dear Raja,

kindly find the attached file.

i hope it will help you.

Thanks, !

Mukram. !

Re: filtering and grouping the data

Tue, 15 Jul 2014 09:10:12 GMT

Dear Mohammed,

Thank you for your generous help, but

I cannot open your file as it stated

Could you please to explain to me how to overcome this issue? or write the syntax here?

Best Regard!

Daniel

Re: Re: filtering and grouping the data

mdmukramali — Tue, 15 Jul 2014 09:13:37 GMT

Dear,

PFA.

Syntax.

Exp 1:

=Count({<Age={"<=3"}>}Age)

Exp 2:

=Count({<Age={">3 <=5"}>}Age)

Exp 3:

=Count({<Age={">5"}>}Age)

Thanks,

Mukram.

Re: filtering and grouping the data

VishalWaghole — Tue, 15 Jul 2014 09:46:44 GMT

Hi Raja,

Try this,

Go to Edit Script,

TEST:

LOAD * Inline [

Age

]

;

LOAD *,

if(Match(Age,1,2,3),'age <=3',

if(Match(Age,4),'3 < age < 5',

if(Match(Age,5,6,7,8),' age >= 5'))) as Age_Range

Resident TEST;

Create Pie chart with Dimension as Age_Range and Expression as Count(Age)

Hope it will make you help.

-- Regards,

Vishal Waghole

Re: filtering and grouping the data

ashfaq_haseeb — Tue, 15 Jul 2014 09:57:50 GMT

Hi,

You can even use Buckets

Script

LOAD *, class(Age,3) as Bucket;

LOAD * Inline

[

Age

]

;

Chart Type Pie Chart

Dimension

Bucket

Expression

count(Age)

Regards

ASHFAQ