Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

Re: Set Analysis Help

Hi Giacomo,

   Due to my data Model, I cant rename and link with Master Calendar. If I rename, I will get circular reference. That's why I am keeping separately.

Partner
Partner

Re: Set Analysis Help

Okay I see,

I tried with a simple example here: the calendar object uses the Master Calendar date field "Ref_Date", and the chart expression is =Sum({$ <Date=Ref_Date>} Amount).

The only thing is that you have to select at least one date to make the chart display a result.

Capture.PNG.png

Otherwise you can solve this by modifying the expression like =Sum({$ <Date=P(Ref_Date)>} Amount)

to get the results even when you don't select any date from your Master Calendar.

Capture.PNG.png


I hope this helps,

Giacomo