Solved: GP CM - Qlik Community

Report Inappropriate Content · ‎2010-07-23

How do I calculate GP for just the current month?

i tried =Sum(If(Month=(Today()),GrossProfit))

but ts not working.

Any ideas?

Thanks

Anonymous · ‎2010-07-23

So both values display as "Jul". In that case it sounds like a simple date mismatch issue.

I assume your month field is a string saying "Jul" instead of an actual date value, while month(Today()) returns "Jul" but with an underlying numeric value, 7.

Take Miha's suggestion and add:

Sum( {<Month = {'$(=text(Month(Today())))'}>} GrossProfit)

Which should work fine with Jonathan's suggestion as well as you need to make sure the string values match up.

View solution in original post

jonathandienst · ‎2010-07-23

If Month here is a field, then try this

=Sum(If(Month=Month(Today()),GrossProfit))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2010-07-23

nope didnt wrk.any other ideas?

jonathandienst · ‎2010-07-23

Is Month a field in the model? If so, is it in a format that can be compared with what's returned from the Month() function?

I usually avoid field names like Day, Month, Year as they are too easily confused with the built in functions.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Report Inappropriate Content · ‎2010-07-23

Its a field yes, and the Month() functon doesnt work tho

Anonymous · ‎2010-07-23

Hi Blaze,

I think you would make this a lot easier to answer if you uploaded an example document. That way everyone can see your date formatting and you should have a quick answer in your hands as there's a number of things that could cause the expression not to return a value.

Report Inappropriate Content · ‎2010-07-23

What about Set Analysis?

Sum( {<Month = {'$(=Month(Today()))'}>} GrossProfit)

Regards,

Miha

Report Inappropriate Content · ‎2010-07-23

I dnt think its possible guys. really sorry. If i enter Month(today()) then it returns the month.

Report Inappropriate Content · ‎2010-07-23

Hey Miha

Close, but its returning the total Gross Profit, not just for this month.

Report Inappropriate Content · ‎2010-07-23

is it possible, that you have different values in Month and Month(Today())?

Example: you have Month = jan, and Month(Today()) returns 1?