Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
sannidhikumar
Creator
Creator

same values in Table

Hi All ,

when i am drill down from Area to LOB i am getting repeated values in table how to resolve this issue.

please find the below attached photo copy and i am using this expression

Round((Sum (CustomerLedger_vw_QlikView.OpenAmount_USD)/sum(Metric))/FX_CONV_RT) .

Capture.JPG

thanks ,

3 Replies
Anil_Babu_Samineni

How you are drilling to next field? Would you tell us the issue to troubleshoot. Because, here we are seeing the Buckets. Could be the reason

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)
sannidhikumar
Creator
Creator
Author

Anil ,

i am drill down from Area to LOB using buckets in the table .

for every buscket i used the expression which i mentioned above .

thanks ,

goro2010
Creator
Creator

You need to exclude the filter Area.

Try this:

=Round((Sum {<Area=>} (CustomerLedger_vw_QlikView.OpenAmount_USD)/sum(Metric))/FX_CONV_RT)