How to check based on condition and display related data?

[#1]

Hi All,

Can any one help me to display all customer names whose available balance is less than minimum balance.

Ex: I  have 3 minimum balance w.r.t 3 Account type I want to check which customer maintain minimum balance w.r.t these 3 acc type and minimum balance value.

I am confused about the approach.. I have used variable  that holds total balance.. now I need to compare that with minimum balance and get corresponding customer name. what should be the expression? or approach?

Regards,

Prajna

[sudeepkm]

I just found that you have a $ symbol in the min balance. you need to remove that while loading so that only numbers will be used. Please change the code as below

tmp:

load purgechar([Mini_FD],'$') as [Mini_FD],

     purgechar([Mini_RD],'$') as [Mini_RD],

     purgechar([Mini_SB],'$') as [Mini_SB]

SQL SELECT "Mini_FD",
                  "Mini_RD",
                     "Mini_SB"
FROM "Personal_Banking".dbo."Minimum_BalanceAmt";.

[sudeepkm]

Please use the purgechar() in the script to ignore any $ sysmbols and reload. Posted in my previous message.

On the UI you can create a straight table using the given below Dimension and Expressions to show the Customer Names and the Account Type where they have below minimum balance.

Dimension:

first dimension: Please enable condition "Supress when value is Null"

=if(FDbalflag=1 or savingsbalflag=1 or otherbalflag=1, [Cust_Id])

second dimension:

[A_typeID]

Expresions:

sum(1)

Go to Presentation: Hide Column for sum(1)

[#4]

Hi,

The value for dimension 1 is not been displayed Its just a hyphen over there

Regards,

Prajna

[sudeepkm]

Please create a table box sheet object in your QVW with all those fields(Cust_ID, Acct Type, min balance, deposit and withdraw). And pls check if you have any customer with available balance less than minimum balance. Pls send me the load script and the snapshot of the table box.