topic Always Display Top 6 brands in QlikView

Always Display Top 6 brands

ipauldur — Wed, 02 Apr 2014 02:59:57 GMT

Hi,

Assume that i have sales value by country, brand, productCategory, Year, Quarter and Month.

Now i want to display always top 6 brands based sales value in each different object (Bar chart dimension is Sales value bucket) based on the selection. They may need to see next top 6 brands also.For that we should have selection. I have more than 1000 brands. But at a time need to display top 6 brands in 6 different bar charts.

Please look at attached screenshot to know the format of display.

Let me know how it can be done. Thanks in advance.

Regards,

Durai

Re: Always Display Top 6 brands

sujeetsingh — Wed, 02 Apr 2014 03:14:05 GMT

Try limiting dimension settings .

Re: Always Display Top 6 brands

Wed, 02 Apr 2014 03:30:13 GMT

Steps:

Define a variable e.g. vTopn

Use the variable in a slider object.

Now use the dimension limits as shown in the screenshot.

Thanks,

Ram

Re: Always Display Top 6 brands

ipauldur — Wed, 02 Apr 2014 03:37:46 GMT

Hi Sujeeth,

Thanks for your reply.

It is already in different object. For example, we have brands A, B, C,& D. Then first bar chart shows sales by sales range (Sales value bucket as dimension) for only brand A. Likewise showing for each brand in different charts. But i want to display top 6 brands (6 barcharts) based sales vales and selections) by default. They may need to see another 6 brands also. So this sorting has to be done in front end as we need to display based any selections. So if any idea please share to me.

Thanks,

Durai.

Re: Always Display Top 6 brands

vikasmahajan — Wed, 02 Apr 2014 03:49:59 GMT

Try this

Vikas

Re: Always Display Top 6 brands

Wed, 02 Apr 2014 03:59:36 GMT

Hi Vikas, Can you kindly elaborate on the expression? especially the usage of "only" here?