topic Re: How to use if Condition in a set analysis in QlikView

How to use if Condition in a set analysis

Anonymous — Wed, 07 Feb 2018 14:03:29 GMT

Hi,

I am trying to restrict the data based on month.

I have below expression in my straight table.

SUM({<TRptCont.RecordType = {'CL'}, TDimMonth.Month=, TDimMonth.MonthIndex = {"<=$(=MAX({test}TDimMonth.MonthIndex))"},TDimMonth.Year=,

TDimMonth.YearNo={">=$(vYR)"}>}(TRptCont.Cont_Count_1))

I want to incorporate the below if statement in the above expression.

=IF(TDimMonth.MonthIndex <= $(=MAX(TDimMonth.MonthIndex)) AND TDimMonth.MonthIndex <= $(=MAX({test}TDimMonth.MonthIndex)) , TDimMonth.Month)

When I am trying to do so I am getting all the value as 0.

Please suggest any solution for this.

Thanks in advance.

Anil_Babu_Samineni — Wed, 07 Feb 2018 14:07:34 GMT

Like this?

=IF(TDimMonth.MonthIndex <= MAX(TOTAL TDimMonth.MonthIndex) or TDimMonth.MonthIndex <= MAX(TOTAL {<test>}TDimMonth.MonthIndex) , TDimMonth.Month)

Anonymous — Wed, 07 Feb 2018 14:22:56 GMT

No, It is not working.

Its still giving the same value.

And I have to use the If condition statement in the expression.

Eg : I have a list box which is having month from Jan15 to Dec 17 and having a table which is giving me Sum(Sales)

I want to restrict the Calculated value only till Jan15 to Dec15.

And I am not using the dimension in the table.

I want to use only expression.

Anil_Babu_Samineni — Wed, 07 Feb 2018 14:26:59 GMT

May be this?

Sum({<month = {">=$(=Date(Min(month), 'MMMYY'))<=$(=Date(AddMonths(month, -2), 'MMMYY')"}>} Sales)