Solved: Formula to expression - Qlik Community

Report Inappropriate Content · ‎2012-02-13

Hi ya'll!

I'm trying to create a simple sales / customer group report but I need to create a formula to the expression since I don't have an total sum field. The formula would would be:

sum of (quantity) * (unit price)

Any tips on this one?

Cheers!

Report Inappropriate Content · ‎2012-02-13

Hi,

In your load script, just write a line like

quantity * [unit price] as TotalPrice;

Regards,

sebablum

View solution in original post

Report Inappropriate Content · ‎2012-02-13

Hi,

In your load script, just write a line like

quantity * [unit price] as TotalPrice;

Regards,

sebablum

Report Inappropriate Content · ‎2012-02-13

Awesome, worked like a charm!

Thanks a lot mate!

Anonymous · ‎2012-02-13

Glat this helped! Thanks Anttiturunen for also marking the answer are correct. This helps users accumulate points in QlikCommunity and also helps them build their online presence and expertise in QlikCommunity. Have a great day!