How can I make a chart show only the days of the current month....

[#1]

Hi there,

I hope this is an easy one that I am just missing the obvious...

I have a chart where I want to show shipments for a month.  There is only one dimension of this chart, REFERENCE_DT

The only expression currently is SUM(SHIPMENTS)

I would like it so that the user can select a specific REFERENCE_DT, for example July 7 2016, and then have the chart show all the days in July (daily granularity for the current month)

any ideas?  I also have a field called MONTH_YEAR that I can somehow reference.

thanks,

Fraser

[sunny_talwar · Accepted solution]

May be like this:

Sum({<REFERENCE_DT =, REFERENCE_MONTH = P(REFERENCE_MONTH) >}SHIPMENTS)

[jyothish8807]

Hi Fraser,

Try like this:

Sum({<REFERENCE_DT  = P(REFERENCE_MONTH) >}SHIPMENTS)

Dimension: REFERENCE_DT

sum({1<REFERENCE_MONTH={'$(=month(REFERENCE_DT))'}>}Sale)

Regards

KC

[jyothish8807]

Hi Fraser,

PFA

Regards

KC

[#5]

Works like a charm.

Thanks so much for the help!

[Anonymous]

Hi Fraser,

We're glad to see you got the solution you were looking for. Please take a moment to mark replies as correct or helpful, in order to give credit to those who helped you and to designate this thread as Answered.

For more information, see Qlik Community Tip: Marking Replies as Correct or Helpful

Thank you,

Qlik Community Team