4 Replies Latest reply: Mar 21, 2018 11:25 AM by William Christensen RSS

    Using the Subfield as part of the field name

    John Phillips

      Using Qlik Sense,

       

      I'm performing a SubField function on an IT database.  Regretfully, all the drive information is contained within the same field.  I would like to Integrate the Subfield answer into part of the Field name.

       

      Currently have the following

           If("Drive Count">1,SubField(Drives, ' ', 14),'NA')                                                  as "Drive 2 Letter",

           If("Drive Count">1,SubField(Drives, ' ', 18)&' GB',0)                                       as "Drive 2 Size",

           If("Drive Count">1,SubField(Drives, ' ', 23)& 'GB',0)                                       as "Drive 2 Free",

       

      Lets pretend the Drive Letter is D,  I would just like the As to be “Drive E Size” and “Drive E Free”

           If("Drive Count">1,SubField(Drives, ' ', 18)&' GB',0)                                       as "E" & " Size",

           If("Drive Count">1,SubField(Drives, ' ', 23)& 'GB',0)                                       as "E" & " Free",

       

      Hopefully that makes sense…