Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
effinty2112
Honored Contributor

Re: Sequential number instead of Dimension values

Hi Divya,

Maybe:

Aggr(Dual(ID,Rank(Expression)),ID)

Good luck

Andrew

qv_testing
Valued Contributor II

Re: Sequential number instead of Dimension values

Try this,

Make one composite key Script level...

RowNo() &'-'&YourFields as NewField


and in your chart Dimension

SubField(NewField,'-', 1)


OR


Only take RowNo() as Key in script

and in your chart Dimension

SubField(Key&'-'&YourDimension,'-', 1)


Capture.JPG


Good luck

MVP & Luminary
MVP & Luminary

Re: Sequential number instead of Dimension values

How are the IDs currently sorted on the Xaxis?

-Rob

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Rob,

The IDs are supposed to be sorted in descending order of "No. of days open". So all the IDs which have higher value for "No. of days open" will appear on the left and the line will gradually drop because all the IDs with lower value of "No. of days open" will appear on the right side of the chart.

Irrespective of which ID is on X-axis, it has to be numbered 1,2,3.... from left to right. This will help users get a count of IDs instead of the IDs itself.

Thank you.

MVP
MVP

Re: Sequential number instead of Dimension values

If you are using qv12.x or qlik sense, you could probably use sortable aggr() to achieve this.

MVP & Luminary
MVP & Luminary

Re: Sequential number instead of Dimension values

I would try Andrew's suggestion below.

-Rob

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Hi Andrew,

I tried this on sample data, it still shows the ID itself on X-axis. I want it to be named 1,2,3,4..... on the chart.

PFA the sample qvw.

Could you please check & let me know if any change is to be made?

Thank you.

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Hi Marco,

I've attached a sample QVW in a reply to Andrew below.

Please let me know if you need more information.

Thank you.

MVP
MVP

Re: Sequential number instead of Dimension values

This?

divya_anand
Contributor II

Re: Sequential number instead of Dimension values

Hi Tresesco,

Thank you for the quick response.

I see that you have considered RowNo() to number them based on load order, right?

But can we make this chart to show values in descending order like this-

Yet name them 1,2,3,4... from left to right?

Is this possible?