Straight Table - Alternate to Dummy Column for Data Restriction

[fabdulazeez]

I’m working with a Straight Table where I want to show a few dimensions, but only for 1 month of data (e.g., the latest month). To apply this filter, I added a dummy column with Set Analysis like:

Sum({<Month={'$(=Max(Month))'}>} 1)

Is there a better alternative. Also for straight table with chart exploration options, I couldn’t find a way to lock or prevent users from removing the dummy column, which could lead to incorrect or incomplete data being shown 

[Anil_Babu_Samineni]

If you have already calendar in your data model, why can't this at dimension level?

1) If(MonthField=Aggr(Max(TOTAL MonthField), MonthField), MonthField)

I know the set analysis is better approach, But you could have done at measure level and not in dimension level to improve better performance. 

[fabdulazeez]

Thanks @Anil_Babu_Samineni .

I've provided a simple example above.
Also, do you happen to know if calculated dimensions generally perform better than set analysis in terms of performance?

Additionally, is there any way to prevent users from removing either the calculated dimension or the dummy column with Set Analysis when using a new Straight Table (Char explorartion)

[Or]

Typically the approach to this would be to add the set analysis in the real measures, rather than use a dummy. That way you don't have to worry about your dummy being removed. 

If you're only using dimensions with no measures except the dummy one, you could use NOT Isnull(GetObjectMeasure(0)) as a calculation condition to ensure it's not removed. 

You could create a calculation condition using GetObjectMeasure() to check whether a specific measure is used, though I'm not sure if there's a clever way of doing it outside of brute-forcing as many GetObjectMeasure() functions as there are available measures. 

[Lech_Miszkiewicz]

Hi,

In this case I would suggest using built in FILTERS function where you would set filter on your table to be only for last month (either via expression or static flag on calendar)

This is a fairly new feature so its availability depends on the version you are using. That way your table will always be filtered down to last month regardles of what columns are selected in exploration menu.

[fabdulazeez]

Yes, I came across this feature in one of Qlik’s recent videos. However, I believe it’s currently available only in Qlik Cloud Analytics. Can someone confirm this?
It looks promising and could potentially address many of the concerns we've been facing.

[Or]

---

@fabdulazeez wrote:

Yes, I came across this feature in one of Qlik’s recent videos. However, I believe it’s currently available only in Qlik Cloud Analytics. Can someone confirm this?
It looks promising and could potentially address many of the concerns we've been facing.

---

Correct. It should be included in the upcoming Enterprise version, though, I believe.