Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
What do you mean by where it's=1?
Hello
Please share sample data
Would you be able to share some sample data for understand?
hi
sum({<[User Name]-={1},[Transaction Type]-={'Savings'}>}sales)
CONCAT(
{1<[Transaction Type]={"Savings"},
<yoursecond_Condition>={"1"}>}
DISTINCT User_Name,',')
try with mapping table!
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
Hi ,
Share the some sample data or QVW application for better understand of your requirement.
Thanks,
Venkata Sreekanth