topic Re: Dimension Calculation Incorrect in QlikView

Dimension Calculation Incorrect

Anonymous — Mon, 14 Apr 2014 07:36:37 GMT

Dear Team,

I am facing the issue in Calculation into the dimension.

The Expression which i have written into Text object is working Correctly on Month Selection,

when I put the same expression into Table Chart it showing the incorrect value.

Can Any one help me out.

Please find the sample application for your references.

Can Any One please help me out.

Regards,

Alok

Re: Dimension Calculation Incorrect

tresB — Mon, 14 Apr 2014 07:45:16 GMT

Are you expecting same value(8986/9002) across the months in chart? If so, use TOTAL keyword in the count() function.

Re: Dimension Calculation Incorrect

its_anandrjs — Mon, 14 Apr 2014 07:53:15 GMT

When you use Month as dimension then your expression which is in text box distributed in each month i think it is total amount try to remove once for check Month dimension from straight table and check values it is your expected value.

Regards

Re: Dimension Calculation Incorrect

Anonymous — Mon, 14 Apr 2014 08:27:57 GMT

Dear Folks,

Thanks for your reply,

Yes I my expected value are showing the correct Value. When I select a Single month into straight Table with use of TOTAL Function.

But If i will select only Year it should display individual Month Value for the Year when no Single Month has been selected.

Dear Anand,

I can Not Remove the Month from the dimension I want to display it Month wise all the values which are showing into Text Box.

IF any other method is there please suggest.

Regards,

Alok

Re: Re: Dimension Calculation Incorrect

tresB — Mon, 14 Apr 2014 08:58:05 GMT

Try expression like:

=If(GetSelectedCount(Month), (Count(total DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Yhftvn'},JYear=,Month=>}Pers.no.)

-Count(total DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate-1,-1))"},Flag={'Qkha'},JYear=,Month=>}Pers.no.))

(Count( DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate,-1))"},Flag={'Yhftvn'},JYear=,Month=>}Pers.no.)

-Count( DISTINCT{<Date={"<=$(=MonthEnd(vMaxDate-1,-1))"},Flag={'Qkha'},JYear=,Month=>}Pers.no.))

)

PFA, done for first column.

Re: Dimension Calculation Incorrect

Anonymous — Mon, 14 Apr 2014 09:11:58 GMT

Dear Tresesco,

Thanks for your affords but If i will select the Multiple Months Let Say Jan, Feb & Mar the Output remains the same.

& also note that the Value are having closing & Opening values are different in Each End of the Month where you can see the text objects which are showing the correct output.

but the same month Wise Output can meet my requirements.

Regards,

Alok

Re: Re: Dimension Calculation Incorrect

tresB — Mon, 14 Apr 2014 09:22:30 GMT

That is because, you include Month=, in your expression. Remove that from the desired(when a year is selected or if a month is selected) part of your expression.

Re: Dimension Calculation Incorrect

Anonymous — Mon, 14 Apr 2014 09:30:34 GMT

Dear Tresesco,

I need Month Wise Opening & Closing Item Difference.

If i will remove Month= also does not make any changes

Re: Dimension Calculation Incorrect

Anonymous — Mon, 14 Apr 2014 11:28:50 GMT

Can Any One have Idea About this scenario ??

Re: Dimension Calculation Incorrect

qlikpahadi07 — Tue, 15 Apr 2014 15:06:17 GMT

Hi Pande,

Please find the attachment might b helpful

Cheers!!!

Re: Dimension Calculation Incorrect

Anonymous — Tue, 15 Apr 2014 15:36:36 GMT

Thanks GURU JI,

It is meeting my requirement this what i aspect ed.

Regards,

Alok