Issue with "Date" selection

[qlikviewaf]

Hi Guys,

i have a problem.

If i select Year=2017 and Quarter=Q1 i have as budget result 4253 $

If i select Yera=2017 and Quarter=Q1 and also Month=Jan,Feb,Mar the budget is 4985$

Since the Q1 is = Jan Feb Mar, i don't get why i have this difference!!!

Find attached my APP, thank you for the support!

[tresesco]

I could not open your qvw. Could you share the expression you are using?

[qlikviewaf]

='Budget  $' & round(

if(Count(Day)=1,

((Sum({<Area-={'Area-not-available'}, Day=,Quarter=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)),

ROUND((Sum({<Area-={'Area-not-available'}, Quarter=,Day=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)*$(vWorkingDaysSelected))))

[rohitraut · Accepted solution]

Hello Antonio,

Try this,

Check your variable you have nullify the  Quarter.

""sum({<Quarter=, Day=,Invoice_Date=,Area=,Region=,Region_Description,Product_Line=,Item_Category=>} WorkingDay)""

And Also in Budget expression:

='Budget  $' & round(

if(Count(Day)=1,

((Sum({<Area-={'Area-not-available'}, Day=,Quarter=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)),

ROUND((Sum({<Area-={'Area-not-available'}, Quarter=,Day=,Invoice_Date=>} BudgetUSD)/1000)/$(vWorkingDays)*$(vWorkingDaysSelected))))

.Please find the corrected .QVW.

[tresesco]

And how are the variables vWorkingDays and vWorkingDaysSelected defined? And yes, please let know which value is right that you want to see in both the cases.

[rohitraut]

please close the thread by marking the correct response and any helpful responses...