Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
danosoft
Specialist
Specialist

Table calculation condition

Hi i have a Table with my rows, i want in it make a condition when i select che month connect to it (The month i choice is the field MESEFINEFORN)

When i click on my choice MESEFINEFORN i want the table will be filter for it, and all is good, is simple..... but in the same time i want my table will be filter for this condition:  D_FINE_VAL>D_FINE_FORN   (are two dates

so i set in my calculation condition this: =GetFieldSelections(D_FINE_VAL)>GetFieldSelections(D_FINE_FORN)

but i see this is not function..... like you see in the picture, where is the fault?

10 Replies
danosoft
Specialist
Specialist
Author

Hi i solved it, the solution is this, if it can be helpful for someone:

Sum({<D_FINE_VAL={"=D_FINE_VAL<=D_FINE_FORN"}, MESEFINEVAL = {"$(=MaxString(MESEFINEVAL))"}>}CONSUMO_TOT_ANNUO)