Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I am a beginner on the Qlik software. I managed to make several graphs and several set analysis. however I am stuck on a function. I want my sheet to open taking into account that the data or my column (="date cloture") are empty. I did not succeed in writing the set analysis which takes into account the check of the empty elements.
Could you help me to know exactly the correct syntax?
Have a nice day
count({$<[Avis_ Date de clôture.autoCalendar.Date]="">} [Avis_ Auteur])
Almost there, only missing the parenthesis.
Count({$<[Avis_ Date de clôture.autoCalendar.Date]={""}>} [Avis_ Auteur])
Almost there, only missing the parenthesis.
Count({$<[Avis_ Date de clôture.autoCalendar.Date]={""}>} [Avis_ Auteur])