topic Re: Regarding Dimensions Grouping in QlikView

Regarding Dimensions Grouping

Tue, 17 Jun 2014 14:11:22 GMT

Hi, I am a total beginner to Qlikview and I can appreciate some help. I created a pivot table with group dimensions of rates. So, the rates would range from 0 to 1. I grouped them by .01 using the class function =Class(Field,0.01). How do i group them from .01,.02........,.09,.10, and THEN .10 and up (basically .10-1.00). I want a specific group row with all values from .10 to 1.00. Also, I can't display the sum at the buttom. Nothing is appearining. Thank you and I would appreciate any help.

Re: Regarding Dimensions Grouping

Gysbert_Wassenaar — Tue, 17 Jun 2014 14:37:55 GMT

In a pivot table you can add totals by enabling Partial Sums for the dimensions on the Presentation tab.

If you want a special class you can use an if statement in combination with the class function. Something like:

if(Field>=.10 and Field<=1.00, '.10<=x<=1.00', class(Field,0.01)) as Group

Re: Regarding Dimensions Grouping

Tue, 17 Jun 2014 14:51:10 GMT

Hi Gysbert, the partial sums worked perfectly. Thank you.

For the special class, this is my IT statement but, it's just grouping everything into the .10<=x<=1.00

I tried adding the as Group, but it said Garbage after As as an error in the expression builder. Do i have to use the group functionality for this one?

Re: Regarding Dimensions Grouping

Gysbert_Wassenaar — Tue, 17 Jun 2014 18:47:18 GMT

The as Group is for use in the load script. If you're using that expression as a chart expression then you need to leave out the as Group since you're not creating a new field.

Re: Regarding Dimensions Grouping

MarcoWedel — Tue, 17 Jun 2014 20:29:38 GMT

maybe this thread helps also?

Custom Filter(unusual range)

regards

Marco

Re: Regarding Dimensions Grouping

MarcoWedel — Wed, 09 Jul 2014 13:52:32 GMT

Hi,

please close this thread if there are no further questions.

Thanks

Regards

Marco