Help in expression as the expression is not working?

[#1]

Hi,

I have Straight table. The data is coming from excel sheet.

Dimension: Member

Expressions are

Number: Count(Distinct(ID))

Fail: count({<[Result]={'Fail'}>}Distinct ID)

When I am using the second expression(Fail) the values are showing zeroes eventhough the excel sheet contains data for fail. Please can anayone help me.

Thanks.

[arsal_90]

Hi Amalia

Please find the attached file.

And See the Cross Table Statement. If it is not fulfill your requirement then let me know

[#3]

Thanks. I would need the ones which are Blanks also. because Blank values represents Pass. Is it possible?

EDIT: Strange for me it is not getting Pass values. It is showing under Pass completely Zeroes.

I used the expression  as

count({<[Overall Result]={'Pass'}>}Distinct ID

Any help please?

[srchilukoori]

in the app, I replaced blanks with zeroes. The passing records are available.

[#5]

Sorry actually my requirement is to show

A summary of how many reports were reviewed, failures and % of failures by Member.

e.g.

Table

Member    No of reports reviewed       No of failures            % of failures
XX  
----  
-----

[#6]

Thanks. Is it possible to right Trim all at a once. because in originla excel file I have so many columns?

[arsal_90]

Can u elaborate your requirement in excel file because i already done Blank with zeroes in other word u can say Pass

[arsal_90]

in simple u can easily achieve the data which is in excel is coming null so replace that null with zero in excel else you can also do in qlikview but u should do for every column

[#9]

Thanks. I need to show the data from excel to Qlikview by creating a table as below

A summary of how many reports were reviewed, failures and % of failures by Member.

e.g.

Table

Member    No of reports reviewed       No of failures            % of failures
XX  
----  
-----

[#10]

Sorry if I am not clear. Please see attached excel. I need to show the data fro below requirement.

A summary of how many reports were reviewed, failures and % of failures by Member.

e.g.

Table

Member    No of reports reviewed       No of failures            % of failures
XX  
----  
-----

I can not use Load *

Dup:

CrossTable([Error Type], Status, 5)

Load *

FROM

Dup.xlsx

(ooxml, embedded labels, table is Dup);

[#11]

Please help me as I used below but it is showing incorrect values.

Dup:
CrossTable([Error Code], [Error Flag], 5)
LOAD Trim(Member) as Member,
     Date,
     [Id],
     [Overall Result],
     [Score],
     [1A],
     [1B],
     [1C]

     ;
LOAD Member,
     Date,
     [ID],
     [Overall Result], 
     [Score],
     IF(Len(Trim([1A])) = 0, 0, [1A]) As [1A],
     IF(Len(Trim([1B])) = 0, 0, [1B]) As [1B],
     IF(Len(Trim([1C])) = 0, 0, [1C]) As [1C] 
 

FROM
Dup.xlsx
(ooxml, embedded labels, table is Data);