Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Set Analisys with OR

Hi, i need to do a Set Analisys like this:

Sum({<DATA_IN={"=Aggr(Max(DATA_IN), COD_PUNTO)"},{STATO_OUT='CESSAZIONE' OR STATO_OUT='RECESSO'}>} CONSUMO_TOT_ANNUO)

where the first filter DATA_IN must be in AND with STATO_OUT, STATO_OUT in same time must be in OR like you see in example.

but this i write not work....

1 Solution

Accepted Solutions
sunny_talwar

Try this

Sum({<DATA_IN = {"=Aggr(Max(DATA_IN), COD_PUNTO)"}, STATO_OUT = {'CESSAZIONE', 'RECESSO'}>} CONSUMO_TOT_ANNUO)

View solution in original post

1 Reply
sunny_talwar

Try this

Sum({<DATA_IN = {"=Aggr(Max(DATA_IN), COD_PUNTO)"}, STATO_OUT = {'CESSAZIONE', 'RECESSO'}>} CONSUMO_TOT_ANNUO)