8 Replies Latest reply: Jan 23, 2015 1:11 AM by prudhvi teja geddam RSS

    Area:Dual

    prudhvi teja geddam

      Hi all, can any 1 suggest a way 2 my problem:

      ****SCRIPT is

      example:

      LOAD dual(text,no) as [dual-example] from

      [..\sample-data-for-dual.txt]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

       

      ****data in text file

      text,no

      high,1

      medium,2

      low,1

       

      Requirement:

      high,medium,low have 2 b displayed in qlik view. how to do?

       

      problem:

      dual.png

        • Re: Area:Dual
          Henric Cronström

          You cannot assign two different texts to the same number. In your text file, both high and low have the value 1. If you instead use

           

          text,no

          high,3

          medium,2

          low,1

           

          it will work.

           

          HIC

            • Re: Area:Dual
              prudhvi teja geddam

              s henric i knew tat tell me a way of displaying all data by any way like concatenating with any new numbering like tat....as it is client requirement

                • Re: Area:Dual
                  Henric Cronström

                  Dual in combination with that requirement doesn't make sense. So, maybe you should discuss this with your client. Or you shouldn't use dual.

                   

                  I see the following possibilities:

                       no & '. ' & text as Field,

                       Dual(no & '. ' & text, RecNo()) as Field,

                   

                  HIC

                    • Re: Area:Dual
                      prudhvi teja geddam

                      i got when i scripted as:

                      example:

                      LOAD dual(text,no) as [dual-example] from

                      [..\sample-data-for-dual.txt]

                      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

                      load Dual(text &'.' & no,RecNo()) as Fieldnew from

                      [..\sample-data-for-dual.txt]

                      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

                       

                      but not when i scripted as:

                      example:

                      LOAD dual(text,no) as [dual-example] from

                      [..\sample-data-for-dual.txt]

                      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

                      load Dual(text &'.' & no,RecNo()) as Fieldnew resident example;

                       

                       

                      wat might b the reason henric?