topic Calculation Dimension in QlikView

Calculation Dimension

nihhalmca — Wed, 27 Aug 2014 08:16:10 GMT

Hi All,

I need to create a calculate dimension as Top Vendors. like

Top Vendors

Top 10

Top 20

If i click Top 10 application should display top 10 vendors where i used vendor as dimension across application.

When i click Top 20 application should display top 20 vendors where i used vendor as dimension across application.

Regards,

Nihhal.

Re: Calculation Dimension

ashfaq_haseeb — Wed, 27 Aug 2014 08:25:19 GMT

Hi,

have a look at attached application.

Regards

ASHFAQ

Re: Calculation Dimension

tresB — Wed, 27 Aug 2014 08:26:18 GMT

Calulated dimension: two expressions:

1. For top ten (use something like: if(aggr(rank(sum(sales)),vendors)<=10,vendors)

2. For top twenty (use something like: if(aggr(rank(sum(sales)),vendors)<=20,vendors)

Now use conditional enablement of these dimensions, use expression like:

1. =Max(If([Top Vendors]='Top 10', 1,0)

2. =Max(If([Top Vendors]='Top 20', 1,0)

Similarly with the help of set analysis, you can do it in the expression side also(conditional enablement of expressions).

Update: PFA

Re: Calculation Dimension

PrashantSangle — Wed, 27 Aug 2014 08:30:48 GMT

Hi,

Why dont you try with variable

Do like this,

Create one input box to allow user to set value i.e 10 or 20.

Use that variables in chart to display that much top Vendor.

For that you can take Vendor as Dimension and then

Go to Chart Prpoerty-> Dimension Limits->Limits->Show Largest->In Values (Insert Variable Name)

You can create Two chart

one with Top 10 and another with Top 20

and based on selection display those chart

Regards

Re: Calculation Dimension

MarcoWedel — Wed, 27 Aug 2014 08:55:21 GMT

Hi,

one solution might be:

hope this helps

regards

Marco

Re: Calculation Dimension

amit_saini — Wed, 27 Aug 2014 09:03:43 GMT

Nihal,

This may help you, see the attachment.

Thanks,

Re: Calculation Dimension

nihhalmca — Wed, 27 Aug 2014 09:36:42 GMT

Thanks for reply Mohammed.

I have gone through your application but my requirement is different, please see above my discussion.

Regards,

Nihhal.

Re: Calculation Dimension

nihhalmca — Wed, 27 Aug 2014 09:45:43 GMT

Hi tresesco, thanks for your response

i have seen your application, in application sum(value) chart has two columns as top 10 and top 20.

However my requirement is if i select top 10 in list, chart should show top 10 it is fine another thing top 20 it also fine, where i suspecting is if there is no selection at top vendors list. chart displaying top 10 and top 20 columns. actually i want to show without selection full data like one column as vendors. i hope you understand my question.

Regards,

Nihhal.

Re: Calculation Dimension

nihhalmca — Wed, 27 Aug 2014 09:47:08 GMT

My requirement was different.

Re: Calculation Dimension

sujeetsingh — Wed, 27 Aug 2014 09:48:26 GMT

Use dimension limit and a variable to pass the value

Re: Calculation Dimension

nihhalmca — Wed, 27 Aug 2014 09:50:04 GMT

Thanks for your reply.

My req. was different.

Re: Calculation Dimension

nihhalmca — Wed, 27 Aug 2014 09:52:02 GMT

Thanks for your reply.

My req. was different.

Re: Calculation Dimension

manojkulkarni — Wed, 27 Aug 2014 10:09:27 GMT

Go to Chart Prpoerty-> Dimension Limits->Limits->Show Largest-> . Use variable here to define values to be shown. Variable will be assigned from user selection. Sort the data by Y value desc.

Re: Calculation Dimension

nihhalmca — Wed, 27 Aug 2014 10:13:31 GMT

please see my question.

Re: Re: Calculation Dimension

tresB — Wed, 27 Aug 2014 10:21:00 GMT

In that case, Check this qvw.

Re: Re: Calculation Dimension

tresB — Wed, 27 Aug 2014 11:42:53 GMT

Did you check my second reply?

Re: Calculation Dimension

nihhalmca — Fri, 14 Nov 2014 10:21:21 GMT

I resolved it. Please see below steps.

1. Create variable and use it as input box

2. use variable wherever you used vendor dimension (charts..etc.).

3. Give values in input box like 10, 20...etc.

Regards,

Nihhal.

Re: Calculation Dimension

MarcoWedel — Fri, 14 Nov 2014 10:28:39 GMT

please post your solution in a sample app.

thanks

regards

Marco