topic Re: Displaying more dimensions then expected. in QlikView

Displaying more dimensions then expected.

Fri, 06 Dec 2013 04:54:11 GMT

Hi techies,

i have an issue with dimension display

i have an expression to display only max 16 weeks but its displaying more then that the expression is

'rangesum(above(Sum ({<WeekID = {"<=$(=max(WeekID))>=$(=max(WeekID)-15)"}>}[Invoiced Qty in LB]),0,RowNo(total)))' which shuld show me only 16 weeks but its displaying 23 weeks. can some body help me with this issue, its really urgent.

Re: Displaying more dimensions then expected.

jonathandienst — Fri, 06 Dec 2013 05:16:52 GMT

Try limiting the dimension to 16 weeks, use a calculated dimension like:

=Aggr(Only({<WeekID = {"<=$(=max(WeekID))>=$(=max(WeekID)-15)"}>} WeekID), WeekID)

If you are using QV11 or higher, you could use dimension limits instead of a calculated dimension.

HTH

Jonathan

Re: Displaying more dimensions then expected.

Fri, 06 Dec 2013 05:49:53 GMT

Hi,

thanks for your reply but its not working

I am using QV11 and tried largest 16 dimension limits but its displaying largest in terms of qty values not on largest 16 weeks.

Re: Displaying more dimensions then expected.

jonathandienst — Fri, 06 Dec 2013 06:11:45 GMT

Did you try First?

Did you try the calculated dimension?