Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for
Did you mean:
Creator

## Include dimension in expression

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

1 Solution

Accepted Solutions
MVP

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 🙂

11 Replies
Master II
Can you be clear what you want? What dimension you need ?

It is easier to answer when the requirement is clear.
Learning never stops.
Partner - Specialist III

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.

Creator
Author

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.

MVP

May be try this

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

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

MVP

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

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

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.

Learning never stops.
Master II

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/

Learning never stops.
Creator
Author
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
Community Browser