topic Re: Create table with all possible values of a variable in QlikView

Create table with all possible values of a variable

Wed, 09 Jul 2014 15:19:16 GMT

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.

Re: Create table with all possible values of a variable

Gysbert_Wassenaar — Thu, 10 Jul 2014 09:07:57 GMT

tmp:

load distinct f1 resident f1_source_table;

join (tmp)

load distinct f2 resident f2_source_table;

result:

load f1*f2 as f3

resident tmp;

drop table tmp;

Re: Create table with all possible values of a variable

MarcoWedel — Thu, 24 Jul 2014 21:45:58 GMT

Hi Adrian,

one demo application that might help:

table1:
LOAD RowNo() as ID1,
    RowNo() as num1
AutoGenerate 20;

table2:
LOAD RowNo() as ID2,
    RowNo() as num2
AutoGenerate 20;

NoConcatenate
table3:
LOAD Distinct * Resident table1;
Join (table3)
LOAD Distinct * Resident table2;
Left Join (table3)
LOAD Distinct
  num1,
  num2,
  num1*num2 as num3,
  RowNo() as ID3
Resident table3;

DROP Fields num1, num2 From table3;

regards

Marco