Excluding values in separate fields

[sbusisochiya]

Qlik Develops.

I'm having two fields 'Transaction Type' and 'User Name'.

now i want to return values of 'User Name' where it's = '1' and on transaction Type is = 'Savings'.

kindly advice.

[shiveshsingh]

Hi

What do you mean by where it's=1?

[rohitraut]

Hello

Please share sample data

[qv_testing]

Would you be able to share some sample data for understand?

[Chanty4u]

hi

sum({<[User Name]-={1},[Transaction Type]-={'Savings'}>}sales)

[ychaitanya]

CONCAT(

{1<[Transaction Type]={"Savings"},

<yoursecond_Condition>={"1"}>}

DISTINCT User_Name,',')

[Anonymous]

try with mapping table!

[vishsaggi]

You want this at script level or in the front end? May be you can try like

= IF(UserName = 1 AND TransactionType = 'Savings', UserName) AS NewUserType

[Anonymous]

Hi ,

Share the some sample data or QVW application for better understand of your requirement.

Thanks,

Venkata Sreekanth