topic Issue with "Date" selection in QlikView

Issue with "Date" selection

qlikviewaf — Thu, 07 Sep 2017 06:51:47 GMT

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!

Re: Issue with "Date" selection

tresB — Thu, 07 Sep 2017 07:19:33 GMT

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

Re: Issue with "Date" selection

qlikviewaf — Thu, 07 Sep 2017 07:37:52 GMT

='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))))

Re: Issue with "Date" selection

rohitraut — Thu, 07 Sep 2017 07:41:38 GMT

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.

Re: Issue with "Date" selection

tresB — Thu, 07 Sep 2017 07:44:56 GMT

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.

Re: Issue with "Date" selection

rohitraut — Thu, 07 Sep 2017 12:28:29 GMT

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