Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Daily Sales of current month without month selection

Hi all

I tried to create a diagram that shows daily sales in the current month without having the current month selected.

I entered following formular in Dimensions / Conditions, etc.

=month(today()) = Month(Fact.Date_Invoiced)

why does it not work?...mmmmmh

Thanks for your help

Oliver

13 Replies
mdmukramali
Specialist III
Specialist III

Dear,

Take Fact.Date_Invoiced as dimension.

and in Expression you can include the set analysis to filter the data for current month.

if it's not clear than attach the sample file so that we can help you.

Thanks,

Mukram.

ashwanin
Specialist
Specialist

Please  provide some example.

ashfaq_haseeb
Champion III
Champion III

Hi,

Check if this helps.

If not, Try to post sample data with expected output to get exact output.

Regards

ASHFAQ

Not applicable
Author

Hi all

sorry, I don't understand why this is not working. Added a short test file...

Thanks for your help.

Oliver

ashfaq_haseeb
Champion III
Champion III

Hi,

Try like this

=Sum({<Fact.Date_Invoiced = {'$(=date(Max(Fact.Date_Invoiced)))'}>} Fact.Net_Rev_EUR)

This was your expression

=Sum({<Fact.Date_Invoiced = {'$(=Max(fact.Date_invoiced))'}>} Fact.Net_Rev_EUR)

Set Analysis is case sensitive.

Your field Fact.Date_Invoiced does not match with  {'$(=Max(fact.Date_invoiced))'

Have a look at attached application too.

Regards

ASHFAQ

its_anandrjs

Hi,

You have to write because some field name missing try this

=Sum({<Fact.Date_Invoiced = {'$(=date(Max(Fact.Date_Invoiced)))'}>} Fact.Net_Rev_EUR)

Regards

Anand

Not applicable
Author

Hi all

Thanks for your help.

Now I get the revenue of the max day, but I want it of the max month per day...

=Sum({<month(Fact.Date_Invoiced) = {'$(=date(Max(Month(Fact.Date_Invoiced))))'}>} Fact.Net_Rev_EUR)

this does'nt work, the result is 0

ashfaq_haseeb
Champion III
Champion III

Hi,

Can you close this thread and open new one for another request.

Regards

ASHFAQ

Not applicable
Author

Why, still looking for "Daily Sales of current month without month selection"...and the solution is close but not there, yet!