Discussion board where members can get started with Qlik Sense.
I have a table as shown below
Now i need to create a table in script(Load editor) such a way that,it has give sum of fruitvalue for each fruitID
I do know that, using table by dimension:fruitID && Expression: fruitvalue i can achieve this,but i need to get from scripting itself like it has to loop for specific fruitIDs and get sum of those.
IS it possible?if not, Could please share reason for this
if yes, How could i do this? Any ideas, suggestion is helpful
You could do something like
group by fruitID
if it is a load inline.
Clearly you can decline it also to a sql select or other things.
you can also do something like
STORE fruits INTO [lib://yourdirectory/fruit.qvd] (qvd);
from [lib://yourdirectory/fruit.qvd] (qvd)
group by fruitID;
Drop Table fruits;
to do not have a table that could be useless.
Try like this
Sum(value) AS TotalFruitvalue
GROUP BY FruitID;