topic Re: ¿How to cout and IF? in QlikView

¿How to cout and IF?

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I have a big problem count with if.

I have 3 fields (in Excel file) ID, DATE1 and DATE2 something like that:

I make a IF combination that depends of some values.

I make a Table in qlik and add as Dimension ID, DATE 1 and DATE 2 and as measure "IF combination"

The table in qlik shows like that:

Previous table works! but i need count YES of this measure and divide by the total ID!

I tried create like a variable (dont works)

I tried make a count(statement) (dont works).

I dont know what to do!

Thanks for all.

maxgro — Fri, 22 Apr 2016 21:11:57 GMT

Script is

LOAD ID,

[DATE 1],

[DATE 2],

[if((interval(AVG({$<] as Field

FROM

(html, codepage is 1252, embedded labels, table is @2);

expression in textbox

=num(count({$ <Field={'YES'}>} Field) / Count(ID), '#,##0.00%')

Fri, 22 Apr 2016 21:53:53 GMT

I have some errors.

Can you send me the .qvf?

Thanks!

MK_QSL — Sat, 23 Apr 2016 08:17:18 GMT

What is the expression which gives you YES and NO?

Sat, 23 Apr 2016 21:16:02 GMT

(if((interval(AVG({$<[Categoria del sitio]={'C1'},[Status]={'Closed'},[Tracker]={'CM'}>}[Displacement time]), 'hh:mm:ss'))<='1','YES',

if((interval(AVG({$<[Categoria del sitio]={'C2'},[Status]={'Closed'},[Tracker]={'CM'}>}[Displacement time]), 'hh:mm:ss'))<='3','YES',

if((interval(AVG({$<[Categoria del sitio]={'C3'},[Status]={'Closed'},[Tracker]={'CM'}>}[Displacement time]), 'hh:mm:ss'))<='3','YES',

if((interval(AVG({$<[Categoria del sitio]={'C4'},[Status]={'Closed'},[Tracker]={'CM'}>}[Displacement time]), 'hh:mm:ss'))<='8','YES',

if((interval(AVG({$<[Categoria del sitio]={'C5'},[Status]={'Closed'},[Tracker]={'CM'}>}[Displacement time]), 'hh:mm:ss'))<='12','YES','NO'))))))

Thanks!