Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Look at this:
I hope this is what you need.
sum(sales) / top (sum(sales))
Joaquín
Hi:
Expression 1: sum(sales)
Expression 2: 100/sum( { < S_sales_month = {1} > } sales) * sum(sales)
Hope it helps
Joaquín
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.
Joaquin, many thanks for your speedy answer. This is exactely what I needed. Great community!
You're welcome