This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a Excel data Sheet like This
Now I want to calculate the number of occurrences of Stops which is (3) but not the count of Stops which is (6)
Thanks in advance
Add in your script a flag :
somethink like that :
if(match(Status,'Stopped'), if(Status<>previous(Status),1,0)) as count,
than in your app as mesure :
see below example :
[Table]:[Table]:load *,if(match(Status,'Stopped'), if(Status<>previous(Status),1,0)) as count;LOAD * INLINE[Wagon,Date,StatusA,01/01/2021,In TravelA,02/01/2021,StoppedA,03/01/2021,StoppedA,04/01/2021,StoppedA,05/01/2021,In TravelA,06/01/2021,StoppedA,07/01/2021,StoppedA,08/01/2021,In TravelA,09/01/2021,StoppedA,10/01/2021,In travelA,11/01/2021,In travel](delimiter is ',');
I didnt test you solution yet
but there might be a B or C wagons between As
then as mesure use aggr function
agrr(sum(count),wagon) to group stopped occurence per wagon