topic Re: Comparative Analysis and Nulls in QlikView

Comparative Analysis and Nulls

ali_hijazi — Wed, 29 Jul 2015 07:46:04 GMT

Hello

I'm using Comparative Analysis in a pivot table

my expression is as follows:

sum({<RECORD_TYPE={'profiling'},CALENDAR_DATE={"=$(=max({<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}>} TOTAL_CPU_USAGE)

and the comparative one is as follows:

sum

(

{[Group 1]

FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

,TPK=$::TPK

,MODULE=$::MODULE

,QC_THEME=$::QC_THEME

,RECORD_TYPE={'profiling'}

,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

}

TOTAL_CPU_USAGE

)

the problem that if I select the same month and Year I don't get the same results because some records have Nulls for MODULE, and QC_THEME

so when I'm writing QC_THEME=$::QC_THEME the null is not included

Please advise

Re: Comparative Analysis and Nulls

ali_hijazi — Wed, 29 Jul 2015 09:04:48 GMT

I found the solution using union

so the comparative expression would be like follows:

sum

(

{[Group 1]

FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

,TPK=$::TPK

,MODULE=$::MODULE

,QC_THEME=$::QC_THEME

,RECORD_TYPE={'profiling'}

,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

}

TOTAL_CPU_USAGE

)

sum

(

{[Group 1]

FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

,TPK=$::TPK

,MODULE=$::MODULE

,RECORD_TYPE={'profiling'}

,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

}

TOTAL_CPU_USAGE

)

sum

(

{[Group 1]

FEEDER_QUALITY_LEVEL=$::FEEDER_QUALITY_LEVEL

,TPK=$::TPK

,QC_THEME=$::QC_THEME

,RECORD_TYPE={'profiling'}

,CALENDAR_DATE={"=$(=max({[Group 1]<RECORD_TYPE={'profiling'}>} CALENDAR_DATE))"}

}

TOTAL_CPU_USAGE

)

Re: Comparative Analysis and Nulls

avinashelite — Wed, 29 Jul 2015 09:55:15 GMT

if you have got the answer please close this thread ....