3 Replies Latest reply: Oct 20, 2014 8:00 AM by Michael Tarallo Branched to a new discussion. RSS

    questions QlikSense development

      Hello

       

      I have been using Qliksense lately and I have raised some questions,

      • Totals of a table are not exported with Excel.
      • If an expression is calculated with an if() how can we show the total?
      • is there a possibility to show/hide a total by individual expression?
      • enlarge/narrow table columns
      • I have an error that appears if there are negative values that are calculated in an expression (in a Pie chart)
      • is there any way to change the dimension Colour

       

      Thank you in advance for your answers

       

      Regards

        • Re: questions QlikSense development
          Michael Tarallo

          Hello Meriem,

           

          I verified the items in your bullet-ed list.

           

          • Totals of a table are not exported with Excel.
            (VERIFIED) - question out to R&D
          • If an expression is calculated with an if() how can we show the total?
            (VERIFIED) - question out to R&D
            Work-around - Instead of calculating the measure in the chart object - calculated as part of the Load Script

           

          • is there a possibility to show/hide a total by individual expression?
            - No - there currently aren't any show / hide conditions in Qlik Sense

          • enlarge/narrow table columns
            -The responsive design - adjust the columns automatically, but I understand why you would want this
            I sent to R&D

          • I have an error that appears if there are negative values that are calculated in an expression (in a Pie chart)
            Please reply with the error

          • is there any way to change the dimension Colour
            Do you mean the dimension value text color in a table or the visual indicator (bars, dots, lines, slice) in a chart object?
            In a chart object (ie. bar chart) - you can color by expression, by measure, by dimension.
            You can use a color expression such as: if (Country = 'Canada','green','red')

           

           

           

           

          Let me know how you do.

           

          Regards,

           

          Mike