topic Re: Expression working on a chart until I sort the dimension in QlikView

Expression working on a chart until I sort the dimension

Anonymous — Wed, 12 Jun 2013 11:39:24 GMT

I have the following expression:

max({1<Year={$(#=vCurrentYear)}, MonthNumber={$(#=vCurrentMonth)}>} MonthlyTarget) // Monthly target
*
(
Sum({1<TimeIsland.Year={$(#=vCurrentYear)}, TimeIsland.MonthNumber={$(#=vCurrentMonth)}, TimeIsland.DayNumber={"<=$(#=vCurrentDay)"}>}TimeIsland.IsShopDay_Int) // Days in month so far
/
Sum({1<TimeIsland.Year={$(#=vCurrentYear)}, TimeIsland.MonthNumber={$(#=vCurrentMonth)}>}TimeIsland.IsShopDay_Int) // Days in month
)

This gets the monthly target for the user, and multiplys it by the number of shop days we've had in the month, divided by the total shop days in the month.

This works nicely providing I don't sort by my User dimension.

If I sort by text A-Z by the user dimension it doesn't show that bar.

I've norrowed it down to the Days in month so far and Days in month parts not getting calculated correctly.

Has anyone encountered anything like this before? It seems very odd to me that sorting a dimension effects the result.

I'm very new to QlikView so I'm probbaly missing something about how QlikView expressions work within charts etc.

Thanks,

George

Re: Expression working on a chart until I sort the dimension

Wed, 12 Jun 2013 11:53:11 GMT

Can u show the qvw file?

Re: Expression working on a chart until I sort the dimension

Anonymous — Wed, 12 Jun 2013 11:56:28 GMT

Could I upload it without data? How do I do that?

Re: Expression working on a chart until I sort the dimension

Wed, 12 Jun 2013 12:03:06 GMT

Open qlikview desktop with a Start page. Choose recently opened documents and with the right click "open without data".

Re: Expression working on a chart until I sort the dimension

Anonymous — Wed, 12 Jun 2013 12:09:02 GMT

See attached.

Re: Expression working on a chart until I sort the dimension

Wed, 12 Jun 2013 12:41:12 GMT

I guess it might be the issue that u have the expression named as the variable in the script, i mean "MonthlyTarget". Try to change the label of expression.