Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be like this:
Sum({<REFERENCE_DT =, REFERENCE_MONTH = P(REFERENCE_MONTH) >}SHIPMENTS)
May be like this:
Sum({<REFERENCE_DT =, REFERENCE_MONTH = P(REFERENCE_MONTH) >}SHIPMENTS)
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
Hi Fraser,
PFA
Regards
KC
Works like a charm.
Thanks so much for the help!
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