Dimension Calculation Incorrect

[Anonymous]

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

[tresesco]

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

[its_anandrjs]

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

[Anonymous]

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

[tresesco]

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.

[Anonymous]

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

[tresesco]

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.

[Anonymous]

Dear Tresesco,

I need Month Wise Opening & Closing Item Difference.

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

[Anonymous]

Can Any One have Idea About this scenario ??

[qlikpahadi07 · Accepted solution]

Hi Pande,

Please find the attachment might b helpful

Cheers!!!