topic Sum the values matching a criteria in QlikView

Sum the values matching a criteria

Wed, 01 Apr 2015 16:21:42 GMT

Hi guys,

I have a simple question that's making me crazy, but I'm a newbie in qlik and I'm doing some practice right now.

I have a data with these information:

ID | Duration

1 | 10

2 | 4

3 | 5

1 | 6

5 | 9

2 | 12

I have to create an expression for a graph in order to get the sum of the duration for each IDs. The result I'm expecting is:

1 -> Sum: 16

2 -> Sum: 16

3 -> Sum: 5

... and so on for all the records in my data source.

How can I accomplish that? I have a strong background in excel and I was trying to look for a function like SUMIFS, but reading some of the posts in the community I noticed that the subject is different than I though.

Thanks to all

Maurizio

Re: Sum the values matching a criteria

Wed, 01 Apr 2015 16:26:47 GMT

Plz. see the attached and let me know if you any queries

Re: Sum the values matching a criteria

ramoncova06 — Wed, 01 Apr 2015 16:29:41 GMT

Hi Maurizio this can be done with set analysis A Primer on Set Analysis

Re: Sum the values matching a criteria

Gabriel — Wed, 01 Apr 2015 16:35:19 GMT

Hi,

I think if you make the Dimension to be ID and your expression should just be

=Sum(Duration).

This should give you the of each ID.

Hope this helps

Re: Sum the values matching a criteria

Wed, 01 Apr 2015 16:38:03 GMT

Hi guys,

I've solved my doubt using this expression: =Sum( if( Type = '1' , Duration))

By the way, thanks to everybody for the replies

Re: Sum the values matching a criteria

Wed, 01 Apr 2015 16:51:58 GMT

you can also use sum({<Type ={'1'}>}Duration).

If you have got the help or answer. Then please close the thread by marking any question as answered or helpful

Thanks,

Singh