Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

instead of outer join is there is any other function

Hi.is there is any function other than join to use here to fullfill my requirement

7 Replies

Re: instead of outer join is there is any other function

What is your requirement?? There is no mention of your requirement any where in the post or the document

MVP
MVP

Re: instead of outer join is there is any other function

Maybe. Would you like to tell us what your requirements are?

Re: instead of outer join is there is any other function

What are your requirements?

Have a look at this document on using ApplyMap.

Don't join - use Applymap instead

MVP
MVP

Re: instead of outer join is there is any other function

Hi,

Can you explain what you require exactly with an example and your expected output?  So that it would be easier to analyse and provide the solution.

If you don't want to join then you can use KEEP, it applies the join logic but maintains the two tables separately.

Or you can try ApplyMap() or Lookup().

Hope it helps you.

Regards,

jagan.

Not applicable

Re: instead of outer join is there is any other function

Actually  i want to show stock of material based on plant wise and month, year wise. here i want to show stock of previous month if there is no stock in current monthCapture.PNG

Not applicable

Re: instead of outer join is there is any other function

Actually  i want to show stock of material based on plant wise and month, year wise. here i want to show stock of previous month if there is no stock in current monthCapture.PNG

Not applicable

Re: instead of outer join is there is any other function

i fill the null values by giving is null function. by doing cross join my reload time so much high. so i want to reduce my reload time

Community Browser