topic Re: Call only top1 row from DB help??? in QlikView

Call only top1 row from DB help???

amit_saini — Thu, 15 Feb 2018 07:22:19 GMT

Hi Folks,

I'm having below scenario:

I need to calculate sum of Quantity , in text box -O/P is 63 which is wrong , looks to me we are having some extra values added here , but not sure from where they came.

But table is showing me correct sum which is 36.

Issue is until left join of Global_Station table even text box is showing right "36" as O/P , but when I'm calling "Sub_Station" table for LineSection info this o/p becomes 63, looks like some additional values are coming from this table.

Might be if I read only 1 row of Sub_Station table then this issue might fix , but not sure how to do this.

There might be some other issue , which I'm not able to think.

Any suggestions?

Thanks in advance!

Regards,

Re: Call only top1 row from DB help???

jonathandienst — Thu, 15 Feb 2018 07:28:47 GMT

I think your join is causing double counting of some values. Rather than joining the table, load it the same way without the Left join statement and let QV association take care of the relationship. Then the value should be correct

Re: Call only top1 row from DB help???

karthikoffi27se — Thu, 15 Feb 2018 08:23:59 GMT

Hi Amit,

If you just need load line section field why don't try mapping load.

Many Thanks

Kathik

Re: Call only top1 row from DB help???

amit_saini — Thu, 15 Feb 2018 08:51:52 GMT

Hi Karthik,

I have tried that too , but same result.

regards,

Re: Call only top1 row from DB help???

amit_saini — Thu, 15 Feb 2018 12:08:15 GMT

Hi Jonathan,

If I'm calling alone Interruption table your suggestion is working fine , but I need to concatenate this table in last with CAQ and in CAQ table also I'm calling same Sub_Station table.

Concatenate(CAQ)

Load * Resident Interruption;

Drop Table Interruption;

Calling without join is creating sync keys and on layout side filters for LineSection is not working fine.

Any suggestion?

Regards,

Amit

Re: Call only top1 row from DB help???

jonathandienst — Fri, 16 Feb 2018 04:36:44 GMT

Not really - your problem is wider than the two tables described in your post. This really a case of some thought into the overall design. And why do you have a Sub_Station1 table?