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: 
pennetzdorfer
Creator III
Creator III

Set Reference visualization (Dynamic Dimensions)

I've got the following bar chart:

  • Dynamic Dimension:  $(=DimField) ... allows switching between ValueOld and ValueNew
  • Expression:  count(distinct ItemID)

Now I'm using the "Set Reference" option to compare ValueOld vs. ValueNew. But unfortunately the sorting gets confused ...

Does anyone have an idea? Please find the attached qvw file.

Regards,

Florian

SetReference.png

5 Replies
marcus_sommer

Unfortunately it looks like a "feature" ...

- Marcus

ashfaq_haseeb
Champion III
Champion III

Check this.

Regards

ASHFAQ

pennetzdorfer
Creator III
Creator III
Author

Ashfaq, thanks for your reply - but I don't see any difference.

Doing step 1 to step 3 shows the same weird sort order.

Regards,

Florian

kji
Employee
Employee

You have to manipulate the load order, to achieve this, see changes in loadscript.

Not applicable

Hi Florian

Is this what you're trying to achieve? If so :-

Change the Sort order of your chart.

Currently you are sorting by Numeric Value Ascending.

Sort by Y-Value Ascending.

setrefviz.png

regards

Paulo