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

Number Format Types

Hi

Can someone please help me, I am trying to dynamically set the number format of an expression in a chart

Similar to:


    expItem.Label.v = ActiveDocument.fields(ViewMode&"PivotEx").GetPossibleValues.Item(0).Text

              expItem.NumAdjust = 2    'right align

              expItem.TextAdjust = 2

                    expItem.LabelAdjust = 2    'right align

             

              set expItem = p.Expressions.Item(i).Item(0).Data.ExpressionVisual.NumberPresentation

             

              ' Set the number format

              select case ActiveDocument.fields(ViewMode&"PivotType").GetPossibleValues.Item(0).Text

                    case "Decimal"

                              expItem.Dec = "."

                              expItem.Fmt = "#,##0.00"

                              expItem.nDec = 2

                              expItem.Thou = ","

                              expItem.Type = 11     'fixed decimal

                              expItem.UseThou = 1

                    case "Integer"

                              expItem.Fmt = "#,##0"

                              expItem.Thou = ","

                              expItem.Type = 10     'integer

                              expItem.UseThou = 1


I was wondering if how to find a list of values for expItem.Type, I coudn't find this info from the API guide.

I actually need to set the type to interval

Thanks

Andy

0 Replies