Qlik Community

Qlik Sense App Development

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

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
arusanah
Contributor II

set Analysis help

Can anybody help find error in below expression .I tried but guess I need extra pair of eyes to look .

trying to create a calculated dimension but it error's out .

=only({<[%KEY]={'Ariel'},DATE={>=EndMonth12<=END_DT},Domain1=,Domain2=,Domain3=,Domain4=,Domain5=,Metric=>}MonthYear)

End Month & END DT are fields in my data set.

Help is much appreciated!

3 Replies
Highlighted
vamsee
Valued Contributor

Re: set Analysis help

Try

=only({<[%KEY]={'Ariel'},

DATE

={">$(=Max(EndMonth12)) <=$(=Max(END_DT))"},

Domain1=,Domain2=,Domain3=,Domain4=,Domain5=,Metric=>}MonthYear)

Highlighted
arusanah
Contributor II

Re: set Analysis help

nope still give invalid dimension

Highlighted
vamsee
Valued Contributor

Re: set Analysis help

I don't see anything wrong in the expression.

Make sure your Max(EndMonth12), Max(END_DT), DATE are in same format.