Re: qlikview script or chat expression needed. - Qlik Community

sivavasam

INPUT:

Column1

Column2

Column3

Column4

Test1

Test2

2855791

40309730

446057

6119057848

2855791

40309730

446057

6119057848

-

2855791

40309730

446057

6119057848

-

2855791

40309730

446057

6119057848

-

2855791

40309730

446057

6119057848

-

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057848

-

6119057848

2855791

40309730

446057

6119057850

2855791

40309730

446057

6119057850

-

2855791

40309730

446057

6119057850

-

2855791

40309730

446057

6119057850

-

2855791

40309730

446057

6119057850

-

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

2855791

40309730

446057

6119057850

-

6119057850

OUTPUT REQUIRED FOR CHART EXPRESSION IN QLIKVIEW:

Column1

Column2

Column3

Column4

Test1

Test2

2855791

40309730

446057

6119057848

2855791

40309730

446057

6119057850

Till column 4 data from Table1, column1 , column2,column3 taken as key from Table 1 , Table2, Table3.

column4 value should match with Test1,Test2 or can be null. Table 2 and Table3 one field name is similar which contains the above values mentioned in the Test1 teast2. Alias field name1 & field name2

From Table 2 :Tast1 chart condition applied : if (sum(num( column4)=sum(num(field name1),field name1)

From Table3 :Tast2 chart condition applied : if (sum(num( column4)=sum(num(ffield name2,field name2)

I just wanted to show the missing value in the test1 and test2 corresponding to column4

rubenmarin

Hi, it's very hard to follow the requirements, have you read it and you can follow it?

From the output required chart maybe you need:

- Test1: If(Test1=Column4, Test1)

- Test2: If(Test2=Column4, Test2)

william12342344

You can use a flag approach in QlikView.

Create flags during load:

Final:
LOAD
    Column1,
    Column2,
    Column3,
    Column4,

    If(Exists(Test1, Column4),1,0) as Test1_Flag,
    If(Exists(Test2, Column4),1,0) as Test2_Flag

Resident Table1;

Then in the chart:

Missing Test1:

If(Test1_Flag=0, Column4)

Missing Test2:

If(Test2_Flag=0, Column4)