topic Re: Advice creating a graph for two field using distinct and multiple fields in that expression. in QlikView

Advice creating a graph for two field using distinct and multiple fields in that expression.

wschefter — Wed, 25 Nov 2020 16:16:04 GMT

Hi all;

Here is what I am trying to do: I need to create a graph for a single expression, in this case "Order Reason", but only for 2 of the 12 fields in that expression. I know I can use a filter pane but our executive staff will be reviewing this data and I don't think they need to use a filter pane to get the data quickly. They don't have the time.

I have tried writing the following querey: count([{SetExpression}] [DISTINCT] [TOTAL [<fld {,fld}>]] expr])

Expression: Order Reason

fld: Tool/Upgrade Part Failed On Install (w/in 30 days)

fld: Spares Part Failed On Install (w/in 30 days)

Any help would be greatly appreciated.

Thanks.

Will S

Here is the full list of fields within the expression:

Order Reason

Damaged by FSE During Installation

Normal Wear and Tear

Other

Part Lost / Misplaced by FSE

Part Mis-Ordered by FSE

Part Missing from Spares Order

Part Missing From Tool Shipment

Received Spare Part Damaged

Received Tool/Upgrade with Damaged Part

Spares Part Failed On Install (w/in 30 days)

Tool/Upgrade Part Failed On Install (w/in 30 days)

Wrong from Previous Spares Order

Re: Advice creating a graph for two field using distinct and multiple fields in that expression.

sunny_talwar — Wed, 28 Feb 2018 17:37:04 GMT

Not sure I understand, but do you have a field called Order Reason which can have 12 possible values and you want to only Count where the values is one of the two you listed? May be this

Count({<[Order Reason] = {'Tool/Upgrade Part Failed On Install (w/in 30 days)', 'Spares Part Failed On Install (w/in 30 days)'}>} Measure)

Re: Advice creating a graph for two field using distinct and multiple fields in that expression.

wschefter — Wed, 28 Feb 2018 19:49:15 GMT

Hi Sunny;

Thanks for replying. You are correct in your thinking, I probably just didn't write it correctly. Within the expression Order Reason I am looking at only pulling the count for Tool/Upgrade Part Failed On Install (w/in 30 days) and Spares Part Failed On Install (w/in 30 days).

I copied the formula (query?) and my results gave me a graph that had a zero count for both fields and a graph that had range of -10 to 10. I have hopefully pasted in a picture of the results I am getting.

Like I said, thank you for replying, the help is greatly appreciated.

Will

Re: Advice creating a graph for two field using distinct and multiple fields in that expression.

sunny_talwar — Wed, 28 Feb 2018 22:47:47 GMT

What expression are you using?

Re: Advice creating a graph for two field using distinct and multiple fields in that expression.

wschefter — Thu, 01 Mar 2018 20:20:22 GMT

Sorry for the slow reply. I am using Order Reason for the expression.

Re: Advice creating a graph for two field using distinct and multiple fields in that expression.

binujose1982 — Fri, 02 Mar 2018 04:57:45 GMT

Hi,

Please give filter in Dimension.

if([Order Reason] = 'Spares Part Failed On Install (w/in 30 days)' or [Order Reason] = 'Tool/Upgrade Part Failed On Install (w/in 30 days)' , [Order Reason], null())

Also check the 'Suppress When Value is null' checkbox in Dimension tab.

Re: Advice creating a graph for two field using distinct and multiple fields in that expression.

wschefter — Fri, 02 Mar 2018 20:42:53 GMT

Thanks everyone for your help. Both answers got me to what I needed to do. I appreciate the help greatly.