Condition not working

[Vince_CH]

Dear,  I want to make some purchase KIP like below indication. it worked well in YTD and LYTD in the fiscal year calendar. as the purchase value originally in different currency, i try to add the condition of PUR_Currency={'RMB'} as in the expression, however, it doesn't work with adding this. can someone help to verify why?? thank you

[Vince_CH]

Gents, another interesting thing is, my original source data was from qvd file exported from Sap, just now i tried to convert the source into excel spread sheet and reconnected with the Qliksense file, then the existing expression doesn't work even without adding the condition. but it works with connecting to original qvd file. 

i will send the sample until somebody give me help how to upload it as above post.

anyone know the reason??

[shiveshsingh]

May be your fields name doesn't match, there could be several reasons.

Are you able to load that excel in your application?

[Vince_CH]

Yes, i can load the excel in the application, but it doesn't work out with result in zero, different with loaded data from qvd file, have no idea why?

[Vince_CH]

i have attached the qvf file as attached with source loaded from qvd file, without the condition PUR_Currency={'RMB'}, now it is working, however if you add this condition, the result turn to be zero. 

[Vince_CH]

as attached is the excel list i converted from the source qvd file, with qvd file the app works well except with adding the condition. however if we load this excel as the source instead,  

Note: the decimal separator in qvd file are comma "," and i have changed it into "." in excel, but whatever as per the original comma or changed dot, the same expression does not give the result, why?

[Vince_CH]

having attached the sample file,

anyone can help me out on this? 

[Anil_Babu_Samineni]

Am i missing anything from previous discussion? I hope, I can load exact like in Excel

PFA

[Vince_CH]

do you use qlikview instead？
i am using qlik sense, can you directly check my qvf file as first attachment to find why the condition doesn't work?

[Vince_CH]

the problem is yet to be fixed. and i explored and find that, with below expression in text, the calculated number 520.51K actually is the sum of the value when PUR_Currency={'EUR'} only. And the value from other currency in RMB, USD, GBP seems to be excluded. i still don't why and someone can help me to correct the following expression?

the sample file was attached in rar file in above post. thanks

='YTD ' & num(Sum({<Year_order,Quarter_order,Month_order,Week_order,[PUR_Order_Date]={"$(='>='&Date(AddYears(YearStart(Max([PUR_Order_Date]),0,7),0), 'DD.MM.YYYY')
& '<='&Date(AddYears(Max([PUR_Order_Date]),0), 'DD.MM.YYYY'))"}>}PUR_Price*PUR_Currency_1)
/1000,'#,##0.00K;($#,##0.00)')