7 Replies Latest reply: May 8, 2015 3:12 AM by Shivendoo Kumar RSS

    Show Only Largest using Dimension Limits Properties.

    Shivendoo Kumar

      Hi Guys,

       

      I came across the Requirement where user should input values to display largest 10, 20 or All

       

      I have implemented this by creating an inputbox and created a varaible vTop and named as Top and the set below properties:

      Input Constraints: No Constraints

      Enable Edit Expression Dialog box=Checked

      Pre-defined Values in Drop-Down=Selected

      Listed Values=10,20, All

      Setting for Selected values=10

       

      Now selected a chart and then went to Dimension Limits Tab--> Select A dimension-->Check the Option 'Restrict Which Values are displayed using the first Expression'

       

      and then Show Only Largest=$(vTop).

       

      I am expecting when I select All It should display all values under that dimension (So basically no Restriction)

       

      How can I achieve this?

       

      Kindly don;t suggest to assign some junk value like 999999999999999999 when vTop=All.

      =IF(vTop='All',999999999,$(vTop)) This is working fine but It will not take more than 99,9999999. If I try 99,99999991, It is giving Message No Data to display.

       

      I am looking for any other Alternates.

       

      Message was edited by: Shivendoo Kumar

       

      Message was edited by: Shivendoo Kumar