topic Create a Chart with a variable in QlikView

Create a Chart with a variable

Fri, 31 Oct 2014 09:59:14 GMT

Hello Members,

I have the following issue:

I want to create a Chart as a table with a Dimension, which gives me the turnover rate for the last 12 months as a letter.

Actually I have two tables. One with Information about the article and one with all stock movements of every article. With both I am able to say, what is the stock in this Moment and was the stock a month ago. I´m also able to say, what is the turnover rate of each article, when the article is the Dimension.

For Example:

Article	Turnover Rate
55555	12,00
44444	11,59

The Problem I have is, that I want to find out, how many article´s have a turnover rate between x and y and how many between y and z and so on...

So i would like to have the following solution:

Turnover Rate	Count(Artikel)
X	5
Y	10
Z	60

I hope, anybody could help me.

Thanks a lot.

Re: Create a Chart with a variable

alexandros17 — Fri, 31 Oct 2014 10:07:54 GMT

Take a look to Rank function ...

Re: Create a Chart with a variable

Fri, 31 Oct 2014 11:05:48 GMT

Thanks for your response, but i didn´t find something helpful for this issue. May be it´s because I am no data analyst specialist.

But I tried something easier...

In the table with the stock movements, there is column with amounts. So when I say ' sum(Amount), I will get the stock of this moment. When I tried this in a dimension i only get an error '//error in the dynamic dim...'

= if (sum(Amount) > 0, 'article with stock', 'article without stock')

So obviously it doesn´t work...

Re: Create a Chart with a variable

alexandros17 — Fri, 31 Oct 2014 11:28:12 GMT

Could you send me the qvw???

Re: Create a Chart with a variable

Fri, 31 Oct 2014 11:50:31 GMT

I send you an email