Sum value Exception

[asknyldz]

Hi there,

Here is the dashboard.

I want to if Account_Status__c = Lower, it should be not sum in chart.

By the way, why i can't see Account_Status__c values in my chart.

Regards,

[Anil_Babu_Samineni]

Because, you don't have data for that. And i did suppress from presentation

[stabben23]

Hi,

you should not use concatenate here, romove it. Qlikview will create a "qlikiviewassociation" for you.

[PrashantSangle]

Hi,

in your script you are concatenating two table. because of that you are not getting values against Account_status__c

Instead of concatenate you have to use join (either left or right or outer).

Regards,

Prashant Sangle

[asknyldz]

Thanks Prashant,

How can i join these tables for Id, could you please advice me.

Load * inline

[

Id,    Amount,

1,100

2,150

3,200

]

;

Load * inline

[

Id,    Account_Status__c,

1,Lower

2,Middle

3,Power

]

;

[its_anandrjs]

Try this ways

Tab1:

Load * inline

[

Id,    Amount

1,100

2,150

3,200

];

Left Join(Tab1)

Load * inline

[

Id,    Account_Status__c

1,Lower

2,Middle

3,Power

];

You get

Id,    Amount,Account_Status__c

1,100,Lower

2,150,Middle

3,200,Power

Regards

Anand

[PrashantSangle]

Hi,

Load * inline

[

Id,    Amount,

1,100

2,150

3,200

]

;

join

Load * inline

[

Id,    Account_Status__c,

1,Lower

2,Middle

3,Power

]

;

For more details search in help menu.

Regards

[sasiparupudi1]

Please use the following expression for sum

sum({<Account_Status__c-={'lower'}>}Amount)

in the script

Change it to following

Table1:

Load * inline

[

Id, Amount,

1,100

2,150

3,200

]

;

Left Join(Table1)

Load * inline

[

Id, Account_Status__c,

1,Lower

2,Middle

3,Power

]

;

[asknyldz]

Thanks Parupudi,

I have below "Table not found" error in my script. What do you think, where is my error?

"Table not found

Left Join(Table1)

Load

    Id,

    Account_Status__c

RESIDENT Account_SQL

WHERE Account_Status__c = 'Rejected'"

CUSTOM CONNECT TO "QvSalesforceConnector";

Opportunity_SQL:

SQL

SELECT

    Id,

    Amount

FROM

    Opportunity

WHERE

    FiscalYear = 2017

;

Account_SQL:

SQL

SELECT

    Id,

    Account_Status__c

FROM

    Account

;

Table1:

Load

    Id,

    Num#(Amount,'0.0') as Amount

Resident Opportunity_SQL

;

Left Join(Table1)

Load

    Id,

    Account_Status__c

Resident Account_SQL

WHERE Account_Status__c = 'Rejected'

;

[PrashantSangle]

write noconcatenate before Table1:

and run. Also check & confirm that can u see Table1 in Table Viewer

Regards,