topic Re: calculated dimension. in QlikView

calculated dimension.

Wed, 14 Jan 2015 09:24:20 GMT

Hi All,

we have created a straight table with one dimension called month and 8 expressions.

requirement was to display only one month in the table.

so we selected Max Number (1-100) to 1 in the presentation tab. by default it displays only Jan when no selection is made on month. when clicked on different months it changes accordingly.

but the user wants to see the previous month values by default.. which should be December when i see in January.

so i tried modifying the dimension with the help of calculated dimension. its not giving expected results when no selection is made on month.

below is the calculated dimension.

=if(GetSelectedCount(Month)=0,Month(AddMonths(MonthStart(Today()),-1))),Month)

please help. any suggestions appreciated.

Thanks

Jyothi

Re: calculated dimension.

Anonymous — Wed, 14 Jan 2015 09:30:28 GMT

Could you post some sample?

Re: calculated dimension.

morganaaron — Wed, 14 Jan 2015 09:36:27 GMT

That expression seems to work for me fine, the only difference I can see is you have an extra bracket after the Today()), -1))) statement - there should only be two brackets needed at the end, not 3.

If that's just a typo, maybe worth posting an example!

Re: calculated dimension.

Wed, 14 Jan 2015 10:09:21 GMT

Hi Aaron.. sorry that was a typo.. i Have attached a sample.. please check..

Re: calculated dimension.

morganaaron — Wed, 14 Jan 2015 10:38:22 GMT

I don't think you want a calculated dimension here - instead try using set analysis on your expression(s), like:

=if(GetSelectedCount(Month)=0, Sum({<Month={"$(=Month(AddMonths(MonthStart(Today()),-1)))"}>}Value), Sum(Value))

I've attached your example here.

Aaron

Re: calculated dimension.

Wed, 14 Jan 2015 11:52:35 GMT

Thanks Aaron.. Issue resolved