topic Re: Excluding values in separate fields in QlikView

Excluding values in separate fields

sbusisochiya — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 22 Mar 2018 16:40:10 GMT

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

rohitraut — Thu, 22 Mar 2018 16:47:36 GMT

Hello

Please share sample data

Nagaraju_KCS — Thu, 22 Mar 2018 16:57:46 GMT

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

Chanty4u — Thu, 22 Mar 2018 16:59:32 GMT

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

ychaitanya — Thu, 22 Mar 2018 17:04:18 GMT

CONCAT(

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

<yoursecond_Condition>={"1"}>}

DISTINCT User_Name,',')

Anonymous — Fri, 23 Mar 2018 01:13:49 GMT

try with mapping table!

vishsaggi — Fri, 23 Mar 2018 01:18:31 GMT

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 — Fri, 23 Mar 2018 07:24:42 GMT

Hi ,

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

Thanks,

Venkata Sreekanth