topic Re: Please kindly assist me on the below requirement . in QlikView

Please kindly assist me on the below requirement .

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

Please kindly assist me on the below requirement .

For the client id 9206070406081 the SBSA bank has two entries with SBSA_Approved_Indicator 1 .

So, it take SBSA DIC as any one value of DIC. But the SBSA Status is not working as its taking two values. How to take one value i.e and show one.

if the values comes one then its 'A' and if its comes as 0 then its 'D'.

sample model attached.

in some examples , its working while if I select the client ID . I need to show the report without selecting the Client ID ....that means it should work for all .....

Thanks ,

Re: Please kindly assist me on the below requirement .

Anonymous — Fri, 01 Jun 2018 08:42:35 GMT

Dear Bhadra,

Do you have duplicate values in your DB..?

Re: Please kindly assist me on the below requirement .

sunny_talwar — Fri, 01 Jun 2018 11:16:48 GMT

This is how your data looks like

LatestForPodium = 1 and LatestForState = 1 doesn't align on a single row for SBSA... also... when LatestForState = 1, Approved_indicator is both 0 and 1...

I am not sure how to read this... can you take a look