topic Re: Total Keyword in Set Analysis in QlikView

Total Keyword in Set Analysis

Tue, 09 Jun 2015 05:59:54 GMT

Hello All,

What is a use of tatal keyword in set analysis?

Thanks in advance..

Re: Total Keyword in Set Analysis

tresB — Tue, 09 Jun 2015 06:07:48 GMT

Total keyword is not specific to set analysis. In short it helps bypass dimensions in a chart. For better understanding read John's explanation here: Keywords : TOTAL, ALL & DISTINCT

Re: Total Keyword in Set Analysis

jonathandienst — Tue, 09 Jun 2015 06:11:33 GMT

The total keyword is not part of set analysis. In a table or chart, it causes the expression to be evaluated without regard to the table or chart dimensions (ie at a total level) - for example:

Sum(TOTAL Sales)

Set analysis is a way of filtering data - eg to sum sales for the North region:

Sum({<Region = {North}>} Sales)

Combined - sum for North region without regard to dimenions:

Sum({<Region = {North}>} TOTAL Sales)

Re: Total Keyword in Set Analysis

jagan — Tue, 09 Jun 2015 06:32:51 GMT

Hi,

TOTAL keyword will ignore the dimensions in the chart. For example if you have sample data like

Branch, Sales

1, 100

1, 200

2, 100

2, 200

Now in chart if you use Branch as Dimension and use below expression

=Sum(Sales)

Now you will get

Branch, Sales

1, 300

2, 300

The same way if you use TOTAL in expression like Sum(TOTAL Sales) then the output would be

Branch, Sales

1, 600

2, 600

TOTAL will ignore the dimension (Branch) and it will sum all sales values and display against each dimension value.

Hope this helps you.

Regards,

Jagan.

Re: Total Keyword in Set Analysis

Tue, 09 Jun 2015 06:41:53 GMT

Hi,

If you want to ignore the dimension and not the selection then you want to use the TOTAL keyword, e.g., sum(total<Date> Sales)