4 Replies Latest reply: Mar 23, 2016 8:37 AM by Michael Granillo RSS

    Filter Pane Text Alignment

    Michael Granillo

      Does anyone know how to fix the text alignment in a filter pane in Qlik Sense?  One of the entries is right aligned and the all others are left aligned.

       

      2016-03-22 13_Qlik Sense.png

        • Re: Filter Pane Text Alignment
          Rohan DSouza

          Hi Michael,

           

          In the 'Field' option of the Dimension tab, write your dimension as

           

          =Text(Column_Name)

           

          All the values will get left aligned.

          Regards,

          Rohan

          • Re: Filter Pane Text Alignment
            Gysbert Wassenaar

            That means that the values of the left are purely text values and values on the right are numbers that may or may not also have a text format. The value 66+ looks like such a dual value that has a numeric value and a display format value that's '66+'. If you want to align all the values the same way then you have to make all of the values numeric values or pure text values.

              • Re: Filter Pane Text Alignment
                Rohan DSouza

                Hi Gysbert,

                 

                Exactly.

                The values that get aligned to the left are text values and those that get aligned to the right are either integer or float or dual values.

                In order to have a single alignment, we have to change all the data types into a single datatype.

                  • Re: Filter Pane Text Alignment
                    Michael Granillo

                    Thank you, your responses have solved my problem.  However, I still find it confusing why Qlik stored '66+' as an interger/float/dual.  There's nothing in my script or chart expressions that treats '66+' differently from the other values that are stored as text. The values in the filter pane were generated via an IF statement:

                     

                    if(age<18,'0-17', if(age<26,'18-25',...,'66+')

                     

                    My issue is solved but was just curious if anyone had thoughts on this.

                    Thanks,

                    Mike