Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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
Master
Master

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

or

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

View solution in original post

14 Replies
BrunPierre
Master
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
Master
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
Master
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
Master
Master

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

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