Indexed data based on the first data of a query

[#1]

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

[JoaquinLazaro]

Hi:

Expression 1: sum(sales)

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

Hope it helps

Joaquín

[#3]

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.

[JoaquinLazaro · Accepted solution]

Hi andreas.griesser

Look at this:

I hope this is what you need.

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

Joaquín

[#5]

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

[JoaquinLazaro]

You're welcome