topic Re: Create a Bar Chart dimension based on Bookmark in QlikView

Create a Bar Chart dimension based on Bookmark

Tue, 16 Oct 2012 20:44:05 GMT

I have a bookmark called "Set1"

I have a field called "company"

I would like to use a the bar chart dimension of "company" based on the bookmarked Set1 company selection(s).

It's probably something obvious, I'm just missing it.

=??({Set1}company)

Any help?

Re: Create a Bar Chart dimension based on Bookmark

Anonymous — Wed, 17 Oct 2012 04:28:27 GMT

You should be able to use "company" as the dimension and then include the bookmark in the expression.

If it's sum(Sales) for example you would use sum({Set1} Sales)

Then if you have suppress zero values turned on for the chart you'll only see dimension values where the expression evaluates to more than 0.

Re: Create a Bar Chart dimension based on Bookmark

Wed, 17 Oct 2012 13:56:01 GMT

So I'm doing a set analysys between two bookmarked sets, Set1 and Set2.

Set1 contains information for one Company or more, and Set2 cointains information on the pool of companies.

I'm using a variable "Percent_Index" as my expression which compares both bookmarks and returns a % of the Set1 score vs. the Pool average score. So in my chart my expression value I have simply the variable: [Percent_Index]

Ideally I would like to plot Companies, but only the companies selected in Set1...

Re: Create a Bar Chart dimension based on Bookmark

Wed, 17 Oct 2012 14:06:42 GMT

I should also note that company is a string - the name of the company.