Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
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?

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() ??

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.