topic Re: Using If statements in QlikView

Using If statements

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

Good Afternoon All,

I am building a pivot table with the below fields

Dimensions: project_name, Full_Name

Expressions:

Sum(IF(DEPT='44840' and Full_Name<>'RF' and Full_Name<>'PT' and project_name<>'PMO IMS Pipeline',HOURS),

Sum(If(DEPT='44840' and epic_summary = 'Internal',HOURS))))

The problem I believe is that i have two fields project_name and epic_summary. Project name is the parent field to epic summary. example: project_name = xyz implementation, epic_summary = xyz credit, xyz internal, xyz traning.

All epic summaries roll up into the xyz implementation.

I want a pivot table that shows me all of the project_names and just one epic summary all in the same pivot table. I am using the above formula to achieve this but it does seem to work. i was wondering if anyone new how to make the above formula work.

Re: Using If statements

tmackay2015 — Wed, 20 Jun 2018 19:55:46 GMT

try:

Sum(

{

$<DEPT={'44840'},Full_Name-={'RF','PT'},project_name-={'PMO IMS Pipeline'}>

$<DEPT={'44840'},epic_summary={'Internal'}>

}

HOURS)

This puts all the filtering logic into set analysis and one expression.

I would also add the epic_summary as a dimension in the pivot table.

What is currently (not) displaying in the pivot table that you want there?

Re: Using If statements

mparker123 — Wed, 20 Jun 2018 20:13:39 GMT

The one epic_summary that i want on the chart

Re: Using If statements

mparker123 — Wed, 20 Jun 2018 20:17:53 GMT

so i entered that in and that does show the proper hours however the name is showing as blank. Is there a way to make the name of the epic summary show up?

Re: Using If statements

tmackay2015 — Wed, 20 Jun 2018 20:22:58 GMT

epic_summary being the value 'Internal'
or some external selection?