Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to avoid aggregate in expression ?

‌Hi All

In order to solve my problem , I need to make use of aggregate function in my expression.

but i am not able to completely solve it. For example I can get YTD amount but I am not able get the LY YTD amount correct.

My question is it is possible using aggregate in partial reload script , this way I can avoid it in expression . Can some one advise me ?

PAul

1 Solution

Accepted Solutions
MVP
MVP

Re: How to avoid aggregate in expression ?

I have not understood what your issue is, but you should be able to use a GROUP BY clause in a LOAD statement with aggregation functions also in a partial reload (using the ADD or REPLACE LOAD prefix).

2 Replies
MVP
MVP

Re: How to avoid aggregate in expression ?

I have not understood what your issue is, but you should be able to use a GROUP BY clause in a LOAD statement with aggregation functions also in a partial reload (using the ADD or REPLACE LOAD prefix).

paulyeo11
Valued Contributor II

Re: How to avoid aggregate in expression ?

‌Hi Stefan

thank you for your sharing , I will try it .

PAul

Community Browser