Include dimension in expression

[stekol61]

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

[pradosh_thakur]

Can you be clear what you want? What dimension you need ?

It is easier to answer when the requirement is clear.

[MindaugasBacius]

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.

[stekol61]

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.

[sunny_talwar]

May be try this

Count({<Incident *= {"*"}>}WO)

[stekol61]

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))

[sunny_talwar]

What does Count(WO) = 3 means here? May be try this

Count(DISTINCT {<Incident = {"=Count(WO) = 3"}>} Incident)

[pradosh_thakur]

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.

[pradosh_thakur]

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/

[stekol61]

Hi!
'3' is the result of 'Count(WO) (per incident)' in the pivot. So i want to count number of "3" per month.
I tried your expression and the result i close to my expressions but a little bit to high