4 Replies Latest reply: Feb 20, 2017 7:00 AM by Agrim Sharma RSS

    how to use measure as dimension?

    Agrim Sharma

      Hi All,

       

      i have an calculated sub filed can i use this as dimension?  if yes then please suggest how?

        • Re: how to use measure as dimension?
          Sachin duganavar

          Hi,

           

          May be u can put tht expression in calculated dimension:

           

           

          Else,Give more clarity on expression u have or try like above..

           

          Sachin

          • Re: how to use measure as dimension?
            Anil Babu

            Yes we can. How is your expression looks?

              • Re: how to use measure as dimension?
                Agrim Sharma

                hi,

                i have Qlik Sense not Qlik View so it will not work

                 

                i have calculated sub fields in script like under:-

                SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 1) * ApplyMap('MappingTable2', [Employee Name]&ROLE, 0) * ApplyMap('MappingTable3', [Employee Name]&Team, 0) * ApplyMap('MappingTable4', [Employee Name]&Month(Date#(Month, 'MMMM')), 0) as [REF BUILD],

                 

                     SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 2) * ApplyMap('MappingTable2', [Employee Name]&ROLE, 0) * ApplyMap('MappingTable3', [Employee Name]&Team, 0) * ApplyMap('MappingTable4', [Employee Name]&Month(Date#(Month, 'MMMM')), 0) as Enable,

                 

                     SubField(ApplyMap('MappingTable1', ROLE, 0), '|', 3) * ApplyMap('MappingTable2', [Employee Name]&ROLE, 0) * ApplyMap('MappingTable3', [Employee Name]&Team, 0) * ApplyMap('MappingTable4', [Employee Name]&Month(Date#(Month, 'MMMM')), 0) as RUN

                 

                and i have did this for 12 months , now i want to have a filter of [REF BUILD], Enable & RUN

                • Re: how to use measure as dimension?
                  Agrim Sharma

                  Hi Anil,

                  Can you help in this?