Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
aatish12345
Creator II
Creator II

Bypassing field in calculated dimension

Hi All,

I have below calculated dimension for "SalesDate" in straight table:

Aggr(Only( [SalesDate]={"=[SalesDate]<=ReportingDate"}>}[SalesDate]),
[SalesDate])...In this calculated dimension I want to bypass Region field, I have done it as shown below

Aggr({<[Region]=>} Only( [SalesDate]={"=[SalesDate]<=ReportingDate"},[Region]=>}[SalesDate]),
[SalesDate])

The expression syntax is OK but in the Region filter is still getting applied on the data.

I want to know is there any other way of bypassing the region field in order to avoid its selection on the data.

 

Aatish

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

Only({1<[SalesDate]={"<=$(=ReportingDate)"}>} [SalesDate])

or

Aggr(Only({1<[SalesDate]={"<=$(=ReportingDate)"}>} [SalesDate]), [SalesDate])

View solution in original post

14 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, How about an expression just like this and then using [SalesDate] as the dimension?

AggregationFunction ({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} Measure)

aatish12345
Creator II
Creator II
Author

Using only on the top of my expression wont allow the table to populat data as it is a date field used as dimension

aatish12345
Creator II
Creator II
Author

Error in table.JPG


this is the error , since it is a calculated dimn so aggr function like only() it is not allowing

BrunPierre
Partner - Master
Partner - Master


Hi, How about an expression just like this and then using [SalesDate] as the dimension?

AggregationFunction ({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} Measure)

aatish12345
Creator II
Creator II
Author

I will get back to you

aatish12345
Creator II
Creator II
Author

Hi, 

You mean adding another expression with aggregation function and then using SalesDate as a dimension?

 

Aatish

BrunPierre
Partner - Master
Partner - Master

Something like.

Sum({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} Sales)

aatish12345
Creator II
Creator II
Author

I cant use sum function since the field is Date field and not any numeric field.

BrunPierre
Partner - Master
Partner - Master

If you want to show the dates as measure, then maybe something like this.

Only({$<[Region]=, [SalesDate]={"<=$(=ReportingDate)"}>} [Date field])