topic Re: If expression with dimension calculation in QlikView

If expression with dimension calculation

Tue, 08 Oct 2013 09:44:51 GMT

I want to create an expression in a straight table where I want the first dimension row to make one summation and the rest of the rows making another sum where there is a condition to sum for the previous month. The dimension of the table is Month called Date.Month in the data model.

=if(Date.Month=vMonth,Sum(InventSum),Sum(InventMonthEnd))

In the If statement above I want the second Summation Sum(InventMonthEnd) to Sum according to the precious month in the dimension.

Sum(InventMonthEnd) for previous Month, Date.Month-1. I dont know how to write this to have it working correct in the expression.

Thanks for any help!

Re: If expression with dimension calculation

Tue, 08 Oct 2013 09:46:32 GMT

Kindly post your data or qvw with restricted data.

Re: If expression with dimension calculation

swuehl — Tue, 08 Oct 2013 09:48:11 GMT

You can use chart inter record functions like above() to evaluate an expression in the context of a previous dimension line:

above(Sum(InventMonthEnd))

Re: If expression with dimension calculation

israrkhan — Tue, 08 Oct 2013 09:54:51 GMT

hi,

have you tried RowNo() function.

=if(Rowno() =1 And Date.Month=vMonth,Sum(InventSum),Sum(InventMonthEnd))

Re: If expression with dimension calculation

Tue, 08 Oct 2013 10:07:30 GMT

Jackpot this works perfect. I had to use the Before function since I had the dimension in the horizontal direction, but same logic and it works great.

Re: If expression with dimension calculation

Tue, 08 Oct 2013 10:08:35 GMT

Dont know if this works since the above answer works fine but it is probably a helpful answer.

Re: If expression with dimension calculation

Tue, 08 Oct 2013 10:10:25 GMT

The data model is way too complex and the calculation I want to make as well for me to post restricted data. That would take a lot of time to have it working correct.