Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

need help to understand a expression ?

Hi All ,

Please assist me in explaining the below expression :

1. vCmhTotalIncome =

sum({

<DOC_Deal_Data.DOCCategory={'DIC Income'}>+

<DOC_Deal_Data.DOCCategory={'First Gross Income'},DOC_Deal_Data.ProductName={'FirstGross'}>+

<DOC_Deal_Data.DOCCategory={'Extra Income'},DOC_Deal_Data.ProductName={'Admin Fee'}>+

<DOC_Deal_Data.DOCCategory={'Vap Income'},DOC_Deal_Data.ProductName={'Body Insurance','Credit Life','Credit Shortfall','Deposit Cover','Maintenance/Service Plan','Road Cover Income','Paint/Glass Protection','Tyre/Rim Warranty','Warranty','Tracking Income','Inflation Protection','Other Income','Comp Insurance'}>

}

DOC_Deal_Data.CommAmount)

2. vCmhTotalIncomeAggr = Aggr(NODISTINCT $(vCmhTotalIncome),Dealer.id)

The  variable (vCmhTotalIncome) is showing value , But the variable (vCmhTotalIncomeAggr) is coming null . I need to find out why its coming null.

Thanks,

5 Replies
Anil_Babu_Samineni

Can you try Variable in text box and show the image?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
suvechha_b
Creator III
Creator III
Author

Capture.PNG

1. vCmhTotalIncome =

sum({

<DOC_Deal_Data.DOCCategory={'DIC Income'}>+

<DOC_Deal_Data.DOCCategory={'First Gross Income'},DOC_Deal_Data.ProductName={'FirstGross'}>+

<DOC_Deal_Data.DOCCategory={'Extra Income'},DOC_Deal_Data.ProductName={'Admin Fee'}>+

<DOC_Deal_Data.DOCCategory={'Vap Income'},DOC_Deal_Data.ProductName={'Body Insurance','Credit Life','Credit Shortfall','Deposit Cover','Maintenance/Service Plan','Road Cover Income','Paint/Glass Protection','Tyre/Rim Warranty','Warranty','Tracking Income','Inflation Protection','Other Income','Comp Insurance'}>

}

DOC_Deal_Data.CommAmount)

The variable (vCmhTotalIncome) no. 1 in text box is showing 96660345 while in the table the total is 323843


2 vCmhTotalIncomeAggr  is coming null.


Thanks,

Anil_Babu_Samineni

Try this for a while

Aggr(NODISTINCT sum({<DOC_Deal_Data.DOCCategory={'DIC Income'}>+

<DOC_Deal_Data.DOCCategory={'First Gross Income'},DOC_Deal_Data.ProductName={'FirstGross'}>+

<DOC_Deal_Data.DOCCategory={'Extra Income'},DOC_Deal_Data.ProductName={'Admin Fee'}>+

<DOC_Deal_Data.DOCCategory={'Vap Income'},DOC_Deal_Data.ProductName={'Body Insurance','Credit Life','Credit Shortfall','Deposit Cover','Maintenance/Service Plan','Road Cover Income','Paint/Glass Protection','Tyre/Rim Warranty','Warranty','Tracking Income','Inflation Protection','Other Income','Comp Insurance'}>}DOC_Deal_Data.CommAmount),Dealer.id)

Note - Instead Dealer.id, It should be your dimensions only. And why want to use NoDistinct with aggr() ??

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Are you suppressing null values for your dimension? If you are then, try to un-suppress them and check if the value matches or not...

If then you want the same number in your text box as your table, just add this to your set analysis

{<Branch = {"*"}>}

pradosh_thakur
Master II
Master II

Hi Suvechha

aggr() creates a temporary table for the dimension you provide inside it. so if you aggr() returns more than one value for  a straight table dimension it will not show up unless you use some agggragation function like sum or max .so my suggestion would be try sum(Aggr(NODISTINCT $(vCmhTotalIncome),Dealer.id)) or sum(Aggr(NODISTINCT $(=vCmhTotalIncome),Dealer.id)) in your table as well as text box and see what result you are getting.



regards

Pradosh

Learning never stops.