topic Problem with the Month dimension in QlikView

Problem with the Month dimension

Tue, 17 Sep 2013 01:55:40 GMT

I am trying to bring the month dimension into an existing App, however when I do my 'Conversion' expression is being affected.

This is the formula I am using for Conversion:

Sum({$ <[Fin Period] = {"<=$(VMaxFinPeriod)"} - {"<$(vMinFinPeriod)"},[Fin Year]=,[Fin Month]=, [Fin Week]=>}[Counter_Sale])
/
Sum({$ <[Fin Period] = {"<=$(vMaxFinPeriodInterviews)"} - {"<$(vMinFinPeriodIntervies)"},[Fin Year]=,[Fin Month]=, [Fin Week]=>}[Counter_Interviews])

This forumla works perfectly when I select on Fin Month in the list box. Does anyone know why when the month dimension is brought in the results change?

Thanks

Re: Problem with the Month dimension

tresB — Tue, 17 Sep 2013 05:01:20 GMT

Assuming you have another field called Month and want to include that in the expression (set analysis). If you want the selection in that field to be disregarded, you have to put Month=, in the set analysis. If you want the selection to filter data accordingly, there should not be anything such in the set.

Re: Problem with the Month dimension

Tue, 17 Sep 2013 05:05:03 GMT

Can you upload the sample application.