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 Excelfile showing the data “as is” and indexed. Any feedback is highly appreciated.
Re: Indexed data based on the first data of a query
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).