topic GP CM in QlikView

GP CM

Fri, 23 Jul 2010 07:47:17 GMT

How do I calculate GP for just the current month?

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

but ts not working.

Any ideas?

Thanks

GP CM

jonathandienst — Fri, 23 Jul 2010 07:57:14 GMT

If Month here is a field, then try this

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

GP CM

Fri, 23 Jul 2010 07:58:48 GMT

nope didnt wrk.any other ideas?

GP CM

jonathandienst — Fri, 23 Jul 2010 08:07:46 GMT

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.

GP CM

Fri, 23 Jul 2010 08:10:03 GMT

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

GP CM

Anonymous — Fri, 23 Jul 2010 08:12:53 GMT

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.

GP CM

Fri, 23 Jul 2010 08:14:54 GMT

What about Set Analysis?

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

Regards,

Miha

GP CM

Fri, 23 Jul 2010 08:16:15 GMT

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

GP CM

Fri, 23 Jul 2010 08:18:41 GMT

Hey Miha

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

GP CM

Fri, 23 Jul 2010 08:19:49 GMT

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

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

GP CM

Fri, 23 Jul 2010 08:20:39 GMT

Try defining also the year in set analysis or in filter.

GP CM

Fri, 23 Jul 2010 08:22:08 GMT

No. My month=Jul and Month(Today()) returns July also...

GP CM

Fri, 23 Jul 2010 08:23:46 GMT

i set

Sum(If(Year = Year(Today()),IF(MonthNumber = Num(Month(Today()))-1,GrossProfit)))

for Previous month GP and it works

Its just the current month that doesnt wrk

GP CM

Anonymous — Fri, 23 Jul 2010 08:29:50 GMT

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.

GP CM

Fri, 23 Jul 2010 08:38:16 GMT

Thanks man that worked perfectly