topic Re: Conditional Sum in QlikView

Conditional Sum

Wed, 26 Mar 2014 09:35:25 GMT

I want to add two quarters on selecting a half year. The two quarters hold the value of the last month of each quarter. So basically i want to sum up the values of the last months of the quarters.

An example:

half-year : 1 quarters : 1 months : June (50 for say)

2 September (100 for say)

so on selecting half year : 1 the expression column should display 150

Any idea on how the expression should be?

Re: Conditional Sum

MK_QSL — Wed, 26 Mar 2014 09:49:57 GMT

Can help you out without checking your sample file or apps but you can try something like this..

For Selecting an entire last month of quarter...

MonthStart(QuarterEnd(Today()))

MonthEnd(QuarterEnd(Today()))

Re: Conditional Sum

Fri, 28 Mar 2014 13:38:56 GMT

Very simple solution if you can change the data model. Modify existing calendar table or add a new table that has the half year preselected.

LOAD * INLINE [
Month, HalfYear
1, 0
2, 0
3, 1
4, 0
5, 0
6, 1
7, 0
8, 0
9, 2
10, 0
11, 0
12, 2
];

Re: Conditional Sum

Anonymous — Fri, 28 Mar 2014 13:47:40 GMT

i think attaching sample data/file with expected output would help in resolving this sooner. you think you can upload a sample data or a qvw?