5 Replies Latest reply: Jan 16, 2012 2:52 AM by Vijay Kumar RSS

    How to seperate Text from an Integer coloumn

      Hi, I am a Beginner in Qlikview.Please help me with the below. Thank You My Source Data is as below:

      Store_ID             Question           Answer

      100                     1                       Y

      101                     2                       N

      100-a                  1                       Y

      100-b                  2                       N


      In the script, I want to input only valid integer Store_ID's and ignore the ones which have 'a' and 'b' in them.


      Store_ID           Question             Answer

      100                      1                       Y

      101                      2                       N