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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
martapardo
Contributor
Contributor

if statement with satisfying two conditions inside set analysis

Hello everyone,

I have a huge table with data about the courses done by the workers of a company, which it is described the course how is the progress on it and which is the responsible of the course, also I have another table with a hierarchy between bosses and workers, since there are  four layers of commanding.  And also this info is upload each month updated, so there is a historical table with the info of every month. So my table is:

tabla1.PNG

and the table output will be:

tabla2.PNG

So I though it could be like that:

= ALT(num (Count(DISTINCT {<aparcamiento_Usuario = {"=Sum(aparcamiento_NO_COMPLETADO) = 0"}>} if([Fecha_exportacion.autoCalendar.Month] = '05',aparcamiento_Usuario,null))/Count(DISTINCT aparcamiento_Usuario),'#,##0.00%'),num (0,'#,##0.00%'))

 

Where Fecha_exportacion = export_date, aparcamiento_Usuario = User, and the "=Sum(aparcamiento_NO_COMPLETADO) = 0"} it means it has completed all courses,;

The condition which is not working is the second one which should be a and so whould satisfied both of them: if([Fecha_exportacion.autoCalendar.Month] = '05', this one and the one of completed al corses

2 Replies
ajaykakkar93
Specialist III
Specialist III

hi,
Did you try doing
{<aparcamiento_Usuario = {"$(=Sum(aparcamiento_NO_COMPLETADO) = 0)"}>}

Please mark the correct replies as Solution. Regards, ARK
Profile| GitHub|YouTube|Extension|Mashup|Qlik API|Qlik NPrinting

martapardo
Contributor
Contributor
Author

This part is working the part that is not working is the other condition the one about the month.

} if([Fecha_exportacion.autoCalendar.Month] = '05', so apart from the if condition =Sum(aparcamiento_NO_COMPLETADO) = 0) I would like that it satidfies aswell the one about the month.