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
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.
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.
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.
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
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.
