topic Re: Show Only Largest using Dimension Limits Properties. in QlikView

Show Only Largest using Dimension Limits Properties.

Thu, 07 May 2015 01:17:11 GMT

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

Re: Show Only Largest using Dimension Limits Properties.

danieloberbilli — Thu, 07 May 2015 02:05:22 GMT

I am sure there is a more elegant way, but one quick & simple solution could be: create a copy of your chart without the dimension limit and use properties >layout > show conditional to show/hide it with vTop condition. So whenever the user selects 'All' the limited chart is hidden and the other is shown and vice versa

Re: Show Only Largest using Dimension Limits Properties.

Thu, 07 May 2015 02:09:07 GMT

I appreciate you response and time.

It won't be a memory over load? because same data we are loading in 2 charts and showing and hiding.

If not then I think it is better solution than =IF(vTop='All',999999999,$(vTop)) .

Re: Show Only Largest using Dimension Limits Properties.

danieloberbilli — Thu, 07 May 2015 02:29:54 GMT

A hidden object shouldnt have any significant effect on the performance at all. I think hidden or minimized objects dont consume any memory at all

Re: Show Only Largest using Dimension Limits Properties.

jagan — Thu, 07 May 2015 03:32:08 GMT

Hi,

Instead of using 999999999, you can get the count and use it in the if statement like below

=IF(vTop='All', Count(Distinct DimensionName), vTop)

Hope this helps you.

Regards,

Jagan.

Re: Show Only Largest using Dimension Limits Properties.

Thu, 07 May 2015 04:28:11 GMT

Jagan,

=IF(vTop='All', Count(Distinct DimensionName), vTop) expression will not work If Count(Distinct DimensionName) crosses 99,9999999.

I have a dimension attribute which is having more than 100 Million records. So =IF(vTop='All', Count(Distinct DimensionName), vTop) I can't use.

Re: Show Only Largest using Dimension Limits Properties.

jagan — Thu, 07 May 2015 05:21:11 GMT

Hi,

Are you using Key field to get Count? Generally in chart we will fields like Customer, Product, Zone etc. If you get Count on this fields then it won't be that much huge number.

Also it is not good practice to display this many records in the charts, reduce the count by forcing users to select some filters.

Regards,

Jagan.

Re: Show Only Largest using Dimension Limits Properties.

Fri, 08 May 2015 07:12:39 GMT

All,

We got 3 Solutions for this:

=IF(vTop='All',99,9999999,$(vTop)) //Limitation: (It will not display any data if data is more than 99,9999999)
Daniel: Show and hide based on vTop value. vTop='All' Show another chart which is not having any dimension Limits else use another which is having dimension limits and pass the value of vTop to limit.
Jagan: =IF(vTop='All', Count(Distinct DimensionName), vTop) //Limitation: (It will not display any data if data is more than 99,9999999)