topic Re: Count-Bucket wise format in QlikView

Count-Bucket wise format

dhanu_today — Mon, 28 Apr 2014 17:50:36 GMT

Hi Everyone,

I have the fields like ID,SAL,DIRECTION.

I have to show the DIRECTION as Dimension , sum(sal) by direction wise,The Count(ID) based on the SAL range.

Please find the attached sample data and the output format as well.The logic development in design level is an added advantage.

Thanks in adv,

Dhanu

maxgro — Mon, 28 Apr 2014 18:14:15 GMT

hope it helps

MK_QSL — Mon, 28 Apr 2014 18:32:52 GMT

Let me try also....

Mon, 28 Apr 2014 18:44:09 GMT

Hello Dhanu,

1. are your ranges disjunctive?

I looked on your sample report and you have for example:

>=5000 in one range, and <= 5000 in another one, so if sale=5000 it should be showed in both ranges????

2. Is number of this ranges and boundaries static or maybe you would like to load it from some external source?

regards

Darek

dhanu_today — Tue, 29 Apr 2014 05:09:41 GMT

Thanks Manish and Massimo its working.

Dariusz - The Data is may be typo mistake.

Dhanu

MK_QSL — Tue, 29 Apr 2014 05:59:09 GMT

Hi,

Kind request you to make correct answer for those who have replied earlier and helpful to others.

This would be the true justice for his/her work.

This will encourage members to reply !

Thanks ....