topic Re: Value not coming correct. in QlikView

Value not coming correct.

renuka_sasikumar — Wed, 10 Dec 2014 09:08:50 GMT

Hi,

I have one Pivot table and one list box(month).

I have given the condition in pivot table that its should give the details of max month.

But there are 4 expression i m getting the max details for 3 but for one i m not getting.

But wen select the month all the values are coming right.

Can anyone pls help me its urgent.

Re: Value not coming correct.

Anonymous — Wed, 10 Dec 2014 09:10:51 GMT

Hi,

Please can post the expression.

Regards

Neetha

Re: Value not coming correct.

renuka_sasikumar — Wed, 10 Dec 2014 09:12:50 GMT

=Count({$<PA000.Date_From={'>=$(vMonthStartDate)<=$(vMonthEndDate)'},fYear={'$(vMaxYear)'},fMonth={'$(=Max(fMonth))'}>}DISTINCT OnRoll)

Re: Value not coming correct.

Anonymous — Wed, 10 Dec 2014 09:20:43 GMT

Hi,

What's the result you are expecting and what's the result?

Regards

Neetha

Re: Value not coming correct.

renjithpl — Wed, 10 Dec 2014 09:27:49 GMT

What are the calendar fileds you have ?

Try to nullify these fields and test it.

Eg.

=Count({$<PA000.Date_From={'>=$(vMonthStartDate)<=$(vMonthEndDate)'},fYear={'$(vMaxYear)'},fMonth={'$(=Max(fMonth))'}, Test_Quarter=, Test_Month=, Test_Week=>}DISTINCT OnRoll)

Please post a sample if possible.

cheers

Ren

Re: Value not coming correct.

Wed, 10 Dec 2014 09:39:02 GMT

Hi Renuka

post all the 4 expression

Re: Value not coming correct.

arulsettu — Wed, 10 Dec 2014 09:53:56 GMT

try this

=Count({$<PA000.Date_From={">=$(=vMonthStartDate)<=$(=vMonthEndDate)"},fYear={"$(=vMaxYear)"},fMonth={"$(=Max(fMonth))"}>}DISTINCT OnRoll)