Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Please kindly assist me on the below requirement .

Hi All ,

Please kindly assist me on the below requirement .

Capture.PNG

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 ,

2 Replies
dilipkumard12
Creator
Creator

Dear Bhadra,

Do you have duplicate values in your DB..?

sunny_talwar

This is how your data looks like

Capture.PNG

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