Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
This pivot shows number of WO's per' Incident'.
In this example this specific 'Incident' has 4 WO's during August.
The calculation used is 'Count(WO)'
I want to see the same thing in a table or graph without using 'Incident' as a dimension
Hahahaha okay, I don't think we have enough information to help you. All we are talking about is what you are seeing and none of us really know what you have.
Unless you are able to share a sample or sample data and expected output from it, I don't think I can offer much help.
But I hope someone else can 🙂
You have two dimensions now: Period and Incident.
The expression is Count(WO).
Remove from Dimensions Incident and you will get the result.
Instead of using Pivot you should use bar/line chart in case you want to see graph.
Hi!
I don't want to use the dimension 'Incident' in the table or chart but i want the calculation to include 'Incident' .
By doing this I hope that the result per month will be the same as in the Pivot without viewing the dimension.
The result should look something as below.
May be try this
Count({<Incident *= {"*"}>}WO)
Hi!
Tried you expression but it shows far to high values.
Not sure what '*' should be
I have used this expression in my table and the the result is close to the correct value:
Sum(Aggr(( COUNT( (WO))=3 ) *-1,Incident))
What does Count(WO) = 3 means here? May be try this
Count(DISTINCT {<Incident = {"=Count(WO) = 3"}>} Incident)
try below
count({<Incident={"=count(WO)=4"}>}Incident)
This will give you the count of incident in a period where count of WO is 4.
To all those like me who were wondering what sunny did with *= in the expression above refer this.
https://www.quickintelligence.co.uk/qlik-set-analysis-star-equals/