topic Re: Load the Condition Table in QlikView

Load the Condition Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I have few other tables in script, i need to add the below condition , Please help

If(Len(Status)=0,[C_Status],Status) As Sale];

Re: Load the Condition Table

Anil_Babu_Samineni — Thu, 28 Sep 2017 05:37:34 GMT

Does Closed Square bracket needed in your statement? remove that and it works

Re: Load the Condition Table

arvind_patil — Thu, 28 Sep 2017 05:39:26 GMT

Hi Suresh,

Try Below one:

Load....

...

If(Len(Trim(Status))>0,Status,[C_Status]) as Sale

From.....

Thanks,

Arvind Patil

Re: Load the Condition Table

avinashelite — Thu, 28 Sep 2017 05:39:29 GMT

What is your actual requirement ????

If(Len(trim(Status))=0,[C_Status],Status) As Sale;

Re: Load the Condition Table

its_anandrjs — Thu, 28 Sep 2017 05:44:44 GMT

You wrongly put the bracket ( ']' ) remove this from script or check your sale field

Try this

Load

If( Len(Status) = 0, [C_Status], Status ) As Sale;

From Source;

Re: Load the Condition Table

Anonymous — Thu, 28 Sep 2017 05:44:58 GMT

From ?

Status is from Temp2 Table

C_Stautus is from Temp 1 and Temp 3 Table.

how should i write the From.......

Re: Load the Condition Table

avinashelite — Thu, 28 Sep 2017 05:51:43 GMT

columns are coming from different tables ?? then you need to map them to one table ..share the complete script will check and suggest

Re: Load the Condition Table

its_anandrjs — Thu, 28 Sep 2017 05:55:14 GMT

On calculated Dimension you can try this or share the sample

If( Len(Status) = 0, [C_Status], Status)

Note:- And values suppress null should be selected.

Re: Load the Condition Table

Anil_Babu_Samineni — Thu, 28 Sep 2017 05:56:23 GMT

Try this? Or post sample application in inline to check

Main:

Load Status From T2;

Join

Load C_Status from T1;

Concatenate

Load C_STatus from T3;

Final:

Load *, If(Len(Status)=0,C_Status,Status) As Sale Resident Main

Drop Table Main;

Main:

Load Status From T2;

Load C_Status from T1;

Inner Join (T1)

Load C_STatus from T3;