topic Re: same values in Table in QlikView

same values in Table

sannidhikumar — Mon, 12 Jun 2017 06:00:15 GMT

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) .

thanks ,

Anil_Babu_Samineni — Mon, 12 Jun 2017 10:07:29 GMT

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

sannidhikumar — Mon, 12 Jun 2017 10:52:33 GMT

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 — Mon, 12 Jun 2017 11:26:17 GMT

You need to exclude the filter Area.

Try this:

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