topic Include dimension in expression in QlikView

Include dimension in expression

stekol61 — Fri, 08 Feb 2019 12:26:29 GMT

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

Re: Include dimension in expression

pradosh_thakur — Fri, 08 Feb 2019 14:01:28 GMT

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

It is easier to answer when the requirement is clear.

Re: Include dimension in expression

MindaugasBacius — Fri, 08 Feb 2019 14:15:41 GMT

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.

Re: Include dimension in expression

stekol61 — Fri, 08 Feb 2019 14:17:04 GMT

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.

Re: Include dimension in expression

sunny_talwar — Fri, 08 Feb 2019 14:21:20 GMT

May be try this

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

Re: Include dimension in expression

stekol61 — Fri, 08 Feb 2019 14:32:15 GMT

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

Re: Include dimension in expression

sunny_talwar — Fri, 08 Feb 2019 14:37:16 GMT

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

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

Re: Include dimension in expression

pradosh_thakur — Fri, 08 Feb 2019 14:36:14 GMT

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.

Re: Include dimension in expression

pradosh_thakur — Fri, 08 Feb 2019 14:41:42 GMT

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/

Re: Include dimension in expression

stekol61 — Fri, 08 Feb 2019 14:44:56 GMT

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

Re: Include dimension in expression

sunny_talwar — Fri, 08 Feb 2019 14:48:04 GMT

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 🙂

Re: Include dimension in expression

stekol61 — Fri, 08 Feb 2019 15:03:09 GMT

OK.

I think that my stakeholders can live with the result even though it slightly differs from the correct value