Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
i have this Formula and would like to add it in a set analysis
Actif/ Day(MonthEnd(Date(Date#(GetFieldSelections(Month_actif), 'MMM')))). I need to add vSetPeriodPres and a field type in our
Could you please elaborate more on this requirement as well as provide prior Expression where we need to include new one? This will help me to understand the situation in better way.
I have to know how many the car is actif in a month :
Load distinct(car),Month(Date) as Month_actif,Year(Date) as Year_actif,
count(1) as Actif
where "Statut"= Actif'
group by car,Month(Date),Year(Date);
so i use this Ratio to know,
So now i need to but this Ratio to a SetAnalysis to add some variable like VsetPeriodPres and type_car ...
May be this:
Please correct me if I misunderstood.
I think we need to use Actif and not Statut=Actif because we have in the script
another thing...in the Ratio we have to add / number of days of the month