Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Indexed data based on the first data of a query

Hi All,

I am new to QV, tried several times but did not manage to create the following:

I’d like to show the results of a query in a line graph (dimension “SalesMonth”, Expression: technical performance, here SpecifiedStrength. The results should be indexed 100 based on the first result of the query . I did not find a function doing this for me in Qlikview, but I am sure this exists. Can you help?

Attached an Excel  file showing the data “as is” and indexed. Any feedback is highly appreciated.

Cheers

1 Solution

Accepted Solutions
joaquinlr
Valued Contributor II

Re: Indexed data based on the first data of a query

Hi andreas.griesser

Look at this:

I hope this is what you need.

sum(sales) / top (sum(sales))

Joaquín

5 Replies
joaquinlr
Valued Contributor II

Re: Indexed data based on the first data of a query

Hi:

Expression 1: sum(sales)

Expression 2: 100/sum( { < S_sales_month = {1} > }  sales) * sum(sales)

Hope it helps

Joaquín

Not applicable

Re: Indexed data based on the first data of a query

Dear Joaquin,

I guess I am not there yet (or wrongly implemented your expressions). Attached the QV file. I only get 1 indexed vale (value is 100, which is a good start ;-)) for the first data of the query. However, I would need the the indexing over all datas.

Important note: the indexing should be dynamic, i.e. should work also when filtering the number of SalesMonths. The indexing shnould always start at 100 for the first value (i.e. at row number 1).

Can you further help? Many thanks.

joaquinlr
Valued Contributor II

Re: Indexed data based on the first data of a query

Hi andreas.griesser

Look at this:

I hope this is what you need.

sum(sales) / top (sum(sales))

Joaquín

Not applicable

Re: Indexed data based on the first data of a query

Joaquin, many thanks for your speedy answer. This is exactely what I needed. Great community!

joaquinlr
Valued Contributor II

Re: Indexed data based on the first data of a query

You're welcome

Community Browser