Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
sujeetsingh
Master III
Master III

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

Not applicable
Author

Works! Great! Many thanks!