topic Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the in QlikView

Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the time

AnkitaC — Mon, 26 Jan 2026 16:26:21 GMT

Hi everyone,

at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the time of data loading after some 1 line is running continuously from 1 hour please check attach screenshot in that that last line is running more that 1 hour please check and give me suggestion.

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

Or — Thu, 16 Mar 2023 12:48:02 GMT

This most commonly means one of two things:

1) The query or load directly after this one is taking forever to respond.

2) There's an attempt to join or keep between two tables which don't share any common fields, resulting in a Cartesian join.

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

marcus_sommer — Thu, 16 Mar 2023 16:42:50 GMT

The loads within the screenshot have around 100 M of records. Maybe your system is just out of RAM ...

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

NadiaB — Tue, 04 Apr 2023 16:30:23 GMT

Hi @AnkitaC

Was this working before and stopped working, or is this the first time you attempt to do this?

Have you verify the two previous suggestions?

Does it always fails in same section?

If you create an app loading just that section of the script, do you see the same result?

Hope it helps!

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

AnkitaC — Mon, 29 May 2023 07:42:35 GMT

Hi,

ROUND(sum(DECODE(POSI_TXN_TYPE, 'S', 1, 'R',0, 1)*((POSI_QTY * (POSI_RATE - NVL(POSI_RATE * POSI_DISC_PERC / 100, 0) - NVL(POSI_DISC_AMT, 0)))
+ NVL(POSI_LOOSE *(POSI_RATE - NVL(POSI_RATE * POSI_DISC_PERC / 100, 0) - NVL(POSI_DISC_AMT, 0))/UOM_MAX_LOOSE, 0))),2) SALE_AMT,

ned to calculate above expression calculation in qlik sense but error occur please suggest me changes

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

AnkitaC — Mon, 29 May 2023 07:42:48 GMT

Hi,

ned to calculate above expression calculation in qlik sense but error occur please suggest me changes

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

marcus_sommer — Tue, 30 May 2023 07:36:46 GMT

It looked that you applied invalid functions like decode() and nvl() in Qlik. I think for nvl() you may use coalesce() or alt() but decode() is unknown to me. Just look on the help within the tool from you have this function how it's worked and is categorized and I think you will also find the Qlik equivalent.

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

AnkitaC — Tue, 30 May 2023 07:39:56 GMT

Thank you for reply i already used alt() for nvl() but not understand this decode () and round() and at the time of using sum() function also error there please guide me what function i will use rather then sum

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

marcus_sommer — Tue, 30 May 2023 07:54:09 GMT

round() is just a rounding - which isn't essentially for the main-logic and therefore just skip this part and add it afterwards if it's really needed.

In regard to the other functions it will depend where you want to use this expression and what's the aim of it. For example should the sum() be used within the script you will need to apply an appropriate group by clause by listing all not within the aggregation used fields. If you don't want to aggregate multiple values from a column else it's aimed as a row-level aggregation you mustn't apply an aggregation-function else a range-function like rangesum(). For decode you will need to look within the tool from which it is to learn what it does.

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

AnkitaC — Tue, 30 May 2023 08:00:15 GMT

Thank you can you please guide how i will apply range sum() example please ?

according to this calculation

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

marcus_sommer — Tue, 30 May 2023 08:17:10 GMT

Just simplify the approach by dividing it in multiple steps. The first one may be just to load a single field from it and afterwards a sum(Field) as X and then step by step the logic is extended.

Beside this I assume that you just copied this statement from another tool and you may have skipped essential parts to get it to work and/or the relevant context. In this case I suggest to comprehend the logic within the origin tool at first because otherwise it will be very hard to adapt the logic within another tool.

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

AnkitaC — Sun, 11 Jun 2023 13:41:40 GMT

Hi Everyone,

how dynamically we can select database in qlik sense f we have one table in that schema name is there means avoiding hard coding or without using inline table hoe we can dynamically change database in qlik sense.

regards,

ankita

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

AnkitaC — Tue, 13 Jun 2023 08:19:29 GMT

Hi Everyone,

dynamic selection of database is possible in qlik sense ?

Re: Hi everyone, at the time of data loading after some in some particular line data is loading there on same line more than 1 hour. actually at the

AnkitaC — Tue, 13 Jun 2023 08:36:09 GMT

please reply means without hardcoding can we dynamically select database?