Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Please kindly assist me on the below requirement .

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 ,

2 Replies

Dear Bhadra,

Do you have duplicate values in your DB..?


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