2 Replies Latest reply: Jul 10, 2014 5:35 AM by Sharma Gopal RSS

    Combine fields in all possible ways

      Hi guys, I'm new to QlikView and I've encountered some difficulties. I have my tables and I have a variable (let's call in var3) that gets updated based on other 2 variables(var1 and var2). These two, var1 and var2 (these variables are numbers), get their values after two selections from two fields(let  and var3 is simply the multiplication of these two variables ( var1 and var2).

      What I am trying to do is to create a list, a table, whatever, with all the possible values for var3. (this actually means that I need some kind of script that would take all the possibilities of choices from f1 and f2 and calculate var3 and then save all the possible values of var3 in a table/list/whatever.

       

      Thank you, I hope I explained myself well.

       

      PS: I have the free version, so it would be great if you could explain me by writing for I cannot open files created by other users.