topic Re: Grouping the values in QlikView

Grouping the values

Fri, 13 Jun 2014 09:04:06 GMT

Hi all,

I have a score values starting from 1,2,3,4.5,5.5.5 .....10. These all values are given by the customers for a specific product which they bought.

Now all I have to do is make group of these score values and show it in a stack chart like 0 to 7.5 should be a group1 , 7.5 to 8.5 should be group2 , 8.5 to 9.0 should be group 3 and 9.0 to 10 should be group 4.

The chart should consist Quarter as X-axis and group values should be in expression shown as stacked chart.

Can you please let me know how to create this group?

I believe i can do symmetric groups with 'Class' function . As this groups are not symmetric I am unable to use Class function.

Any Ideas would be thankful

PS:please find sample data attached

Deepak Vadithala Can you help me in this?

Thanks in advance.

Best regards,

Susvith

Re: Grouping the values

sujeetsingh — Fri, 13 Jun 2014 09:15:09 GMT

You can create the ranges in two ways:

1) Can use nested iff to define the ranges

2) Can use class function

Examples

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

Re: Grouping the values

Fri, 13 Jun 2014 09:15:45 GMT

many solution fr that

1. you can add a colum Group in your xls file

2. you can use IF function but that means to do many If(v < 7.5, G1, if (v < 8.5, G2...)

3. you can create a mapping table l for every value and assign a group for each of it then use applymap('Map_table', value) as group

4. may be an other function i wouldn't know

best regards

Chris

Re: Grouping the values

Anonymous — Fri, 13 Jun 2014 09:16:56 GMT

Hi,

Use the Interval Match function.

Re: Grouping the values

Gysbert_Wassenaar — Fri, 13 Jun 2014 09:18:26 GMT

Use a nested if statement in the script to create the Group field. See attached qvw

Re: Grouping the values

Fri, 13 Jun 2014 09:30:44 GMT

Thank You so much Gysbert , I just forgot that I can divide into groups in script level.

Add on to it , I have one more hurdle here.

For the same scenario , I should show Y-axis in percentage %. Here the Y-axis should show 100% which means at any cost Group1+Group2+Group3+Group4=100%.

Can I show like this in QlikView?

I believe i can use AGGR fucntion here . But I am not sure can you help me?

Thanks in advance.

Best regards,

Susvith

Re: Grouping the values

Gysbert_Wassenaar — Fri, 13 Jun 2014 09:35:05 GMT

Change the expression to count(Visitor)/count(total <Quarter> Visitor)

Re: Grouping the values

IAMDV — Fri, 13 Jun 2014 10:44:42 GMT

Sorry mate. Just saw your message but Gysbert Wassenaar solved it for you.

Cheers,