topic Re: Indexed data based on the first data of a query in QlikView

Indexed data based on the first data of a query

Wed, 10 Dec 2014 09:13:44 GMT

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

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

Joaquin_Lazaro — Wed, 10 Dec 2014 09:32:27 GMT

Hi:

Expression 1: sum(sales)

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

Hope it helps

Joaquín

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

Wed, 10 Dec 2014 14:39:01 GMT

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.

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

Joaquin_Lazaro — Wed, 10 Dec 2014 15:59:25 GMT

Hi andreas.griesser

Look at this:

I hope this is what you need.

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

Joaquín

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

Thu, 11 Dec 2014 07:16:58 GMT

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

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

Joaquin_Lazaro — Thu, 11 Dec 2014 07:24:48 GMT

You're welcome