I have table as a below:
I need to crate table in qlikview like this:
1 - 5
6 - 10
11 - 30
In excel I can use sumif to create table. Here I could not create. Please, help me
Thanks in advance
You have buckets - I would suggest using the intervalmatch function - the help section is particularly good on this subject
try to use class(Capacity,5) as dimension
sum(Premium) as expression
Thanks very much for help. I am new in QlikView that is why I need will. I will write here my questions:)
Does it work as you need?
Yes wonderful. This function divides equal interval. I Now I try ti find unequal intervals
So, you should mark some answer as correct to indicate that your problem is solved
PFA. Hope it helps you.
I laughed when i spotted the correct answer Darek ^^^^
Retrieving data ...