Discussion board where members can learn more about Integration, Extensions and API’s for Qlik Sense.
I need to do the condition :
i have four fields:
if i have one car in 2 differents parc in the same date i need to put these cars in flags
how to do it thanks
Mapping LOAD car&'-'&date as Key,
Count(parc) as Count
Group By car, date;
If(Count>1,1,0) as Flag;
Applymap('ap_Count',car&'-'&date) as Count,
Pls let us know if your requirement is different.
You can try this
<<Your data source>>
if(Count(DISTINCT Parc)>1,1,0) as Flag
Resident Temp group by Date,Car;
In your expression, you can write if sum(Flag)>0, 1,0
I hope this helps.
also, if you share the QVW with us, It would give a better clarity.
PFB: screenshots for better clarity
Can be like this if I understood the task correctly?
[date, car, parc, country
01.01.2017, car1, parc1, country1
02.01.2017, car2, parc2, country2
03.01.2017, car3, parc3, country3
03.01.2017, car3, parc2, country3
04.01.2017, car1, parc1, country1
04.01.2017, car1, parc6, country1
04.01.2017, car1, parc2, country1];
If(Count(parc)>1, 1, 0) as Flag //
Group By date,car;
thanks for everybody i find another solution to resolve it