Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arusanah
Creator II
Creator II

Set Analysis Help

HI Friends ,

I am writing a calculated dimension

=only({<[%KPI_KEY]={'ARIEL'},Metric=}>}if((DATE <= END_DT and DATE >= EndMonth13 ),MonthYear))

it doesn't throw error instead says invalid dimension.  Can anyone help ?

2 Replies
vunguyenq89
Creator III
Creator III

Make sure all fields being used in the expression do exist in the data model.

Can you provide a sample app?

Quy_Nguyen
Specialist
Specialist

Try this:

Aggr(only({<[%KPI_KEY]={'ARIEL'},Metric=>}if((DATE <= END_DT and DATE >= EndMonth13 ),MonthYear)),MonthYear)