Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)