topic Qlikview Join in QlikView

Qlikview Join

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

Hi all,

I have two filters and a requirement as mentioned below,

Each customer having input and output formats each. When input is selected it should show the result compared only for input and similarly for both and output.

But in my script, I've used some looping functions, so I was supposed to write the code in different tabs for input, output and both scenarios.

So in my script, only input comparison is working, since it is first in tab wise. Please help me guys to overcome this and I've also shared my script.

Thanks,

Siva.

Re: Qlikview Join

sunny_talwar — Mon, 21 Aug 2017 13:55:46 GMT

What is the expectation with regards to the things you want to see when different things are selected with Reuseability and Properties?

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 14:06:05 GMT

Customers Input

Cargosmart HR

GTNexus HR

Hapag Lloyd HR

Maersk HR

When a customer and input is selected in reusability, the above customers with same input format of the selected customer need to be displayed in the chart.

If Cargosmart and input is selected in the filters, GTNexus, Hapag Lloyd and Maersk need to be shown and similarly for output.

Re: Qlikview Join

Anil_Babu_Samineni — Mon, 21 Aug 2017 14:20:55 GMT

Still question not clear to me? And you made some expression in Bar graph. Is that is wrong?

If not, If we select something from filters then how you are showing even associate to each where we are getting the right input. Does this not good for you?

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 14:25:29 GMT

No Anil, Let us assume, Customer "Cargosmart" has input format as "A" and Output format as "B".

If Cargosmart and input got selected in the filters, the customers which are having input format as "A" alone should be shown.

if ouput is selected for Cargosmart, the customers which are having output format as "B" only should be shown.

Similarly if both selected, the customers which are having input format as "A" and output format as "B" only should be shown.

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 14:31:20 GMT

But according to my script, it is correct only for input format but not working for output and both scenarios.

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 14:34:08 GMT

Do I need to use if else condition to achieve this? Please suggest any way guys.

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 14:39:20 GMT

My script is working upto these tabs only.

So this works fine only for input but not for output and both. Whether I made a mistake in joins?

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 14:42:08 GMT

Also, if I rearrange the tabs and checked for output, it is working fine for output too but not for input and both as shown below,

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 14:43:37 GMT

Sunny/Anil,

Guys, you got any idea on what I'm trying to say now?

Re: Qlikview Join

sunny_talwar — Mon, 21 Aug 2017 14:57:03 GMT

When you say it doesn't work? Does it show error while reloading or the data is not right?

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 15:16:33 GMT

Sunny,there isn't any error while reloading and data is also right. What I meant was this script is working with only input selections and not for output and both selections perfectly.

Re: Qlikview Join

sunny_talwar — Mon, 21 Aug 2017 15:25:47 GMT

Checking...

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 15:59:58 GMT

Sunny,

Could you find anything wrong in this script?

Re: Qlikview Join

sunny_talwar — Mon, 21 Aug 2017 16:22:24 GMT

Where are these getting joined into?

Re: Qlikview Join

Anonymous — Mon, 21 Aug 2017 17:15:32 GMT

Sunny, This is joined with Fields2 table.