Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Labelling of X-axis based on number of results

Hi,

as a QV beginner I am wondering how I can label the x-axis based on the number of e.g. test results. Example: I have 30 test results to display, so the x-axis should be labelled from 1 to 30. In Excel this works as simple as creating a line chart with only one variable. The numbering from 1 to 30 is done automatically.

In QV I only managed to display the test results by giving each individual result a fixed number, say number 1 to 30. However, this does not work for further filtering.

If above example of test results is filtered to show only values below 50, the outcome is 13 test results. Thus my chart should display 13 consecutive test results, labelled from 1 to 13. Please see excel example attached, sheet unfiltered and sheet filtered.

I guess there is a very simple solution for this problem, however I did not find it yet. Would be great if someone could help me with the right function or formula for this problem. Thanks!

1 Solution

Accepted Solutions

Re: Labelling of X-axis based on number of results

See attached qvw.


talk is cheap, supply exceeds demand
3 Replies

Re: Labelling of X-axis based on number of results

See attached qvw.


talk is cheap, supply exceeds demand
sujeetsingh
Honored Contributor III

Re: Labelling of X-axis based on number of results

I am not clear what you want ....the same as Gysbert replied,

Not applicable

Re: Labelling of X-axis based on number of results

Works! Great! Many thanks!

Community Browser