Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

Dear Bhadra,

Do you have duplicate values in your DB..?

Highlighted

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