Making a chart static only for Date Selections

[#1]

Hi, I'm new to QlikView and am learning as I go.  I'm stuck on trying to make a static chart for Date Selections only.  Basically, I always want the chart to show all of the months even if a single month is selected.  But when other selections are made (i.e. Name) I want the chart to update for Name, but show all months.

This seems to work to make the chart static for everything, but I want it static just for Month.

count({1<Status={'OT'}>}Status)/Count({1}Status)

[chiru_thota · Accepted solution]

Use following expression.It will not respond for only Month.

count({<Status={'OT'},Month=>}Status)/Count({<Month=>}Status)

[#3]

That worked perfect!!  Thank you very much.

[bgerchikov]

Hi,

Month dimension might disappear if you have both dimensions Name and Month in one table. So, when you select some Name, which doesn't have all Months associated with, you will not see all of them displayed. Typically calendar data should be set in the separate table. In addition, try to select Show All Values option in Dimensions tab.

Good luck!