topic Re: Pivot Table in QlikView

Pivot Table

Fri, 23 May 2014 11:53:26 GMT

Good day,

I have table as a below:

I need to crate table in qlikview like this:

In excel I can use sumif to create table. Here I could not create. Please, help me

Thanks in advance

Fri, 23 May 2014 11:55:31 GMT

You have buckets - I would suggest using the intervalmatch function - the help section is particularly good on this subject

Fri, 23 May 2014 11:58:17 GMT

try to use class(Capacity,5) as dimension

sum(Premium) as expression

Fri, 23 May 2014 12:06:10 GMT

Thanks very much for help. I am new in QlikView that is why I need will. I will write here my questions:)

Fri, 23 May 2014 12:09:17 GMT

Does it work as you need?

Fri, 23 May 2014 12:11:33 GMT

Yes wonderful. This function divides equal interval. I Now I try ti find unequal intervals

Fri, 23 May 2014 12:19:18 GMT

So, you should mark some answer as correct to indicate that your problem is solved

regards

Darek

Fri, 23 May 2014 12:27:22 GMT

I laughed when i spotted the correct answer Darek ^^^^

senpradip007 — Fri, 23 May 2014 12:28:07 GMT

PFA. Hope it helps you.

Fri, 23 May 2014 12:33:04 GMT