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

How to sort with the help of macro!

Hi All


We are generating the Straight table with the help of macro. In that one of the field we wants to sort it by "Load Order: Original". For example if the "Dimension=Month" then sort it by "Load Order: Original". How can I achieve this with the help of macro.

Following is the sample of code which we were using in the macro for setting up the number properties. I want to similar kind of coding to add to sort the Dimension: "Month" by "Load Order: Original".

  SET objNumberProperties = objPivotTableProperties.Expressions.Item(intAddedMeasureCount + intLoop).Item(0).Data.ExpressionVisual.NumberPresentation

  objNumberProperties.Fmt = "#,##0.000"

  objNumberProperties.nDec = 0

  objNumberProperties.Thou = ","

  objNumberProperties.Type = 11

Hope some one can help me out on this soon as it is little urgent.

Thanks

Attitude

10 Replies
Anonymous
Not applicable
Author

Hi Deepak,

     Macro is working fine to add a straight table in the active document - active sheet. But is there any way we can add expression and dimension in the macro .