How to find Sales in a month. - Qlik Community

Report Inappropriate Content · ‎2015-11-05

Hi,

kindly let me know the set analysis logic.

find the sales of particular month. ie there are production plants like plant A it uses monthly raw material in tons. and there is date field

i want formula that in text box i want to display monthly consumption if i click on jan i will show jan consumption and so on.

ElizaF · ‎2015-11-05

Try this function for text box

num(Sum( {$} Amount),'#,##0')

Mark_Little · ‎2015-11-06

Hi,

Well depends exactly what you want,

=Sum(Amount)

Will give you amount in the the text box, this will then change on selection.

=Sum({<Plant={'A'}>}Amount)

This will give you the sum of amount for the Plant A and still change on other selections.

Then to format the number you can use the num() function like below.

=NUM(Sum({<Plant={'A'}>}Amount),'£#,##0;-£#,##0','.',',')

Hope this helps.

Mark

Anonymous · ‎2015-11-06

Simple

sum(Sales)

miguelbraga · ‎2015-11-06

Hey there,

To get used to set analysis you may want to read this paper:

Also if you want the value of a month you can make something like this:

=sum({$<[Plant Production Code] = {'Plant A'}, Year=, Month = {$(=max(monthField))}>} Sales)

Regards,

MB