topic Re: Multiple tax ID for same vendor in QlikView

Multiple tax ID for same vendor

Anonymous — Wed, 23 Aug 2017 11:34:57 GMT

Hi,

I want to show multiple/different vendors who have the same TAX ID.

E.g.

VendorNum Tax ID

Vendor1 1234

Vendor2 1234

Possible to show that in a straight table?

Thanks,

Sunny

Re: Multiple tax ID for same vendor

Anil_Babu_Samineni — Wed, 23 Aug 2017 11:37:22 GMT

May be use table Box? Unless why forcing to achieve this in straight table.

Re: Multiple tax ID for same vendor

Anonymous — Wed, 23 Aug 2017 11:38:23 GMT

Yes, you can show the values.

Re: Multiple tax ID for same vendor

tomasz_tru — Wed, 23 Aug 2017 11:41:13 GMT

Use measure: Concat(Distinct VendorNum, ',') and Tax ID as Dimension

Tomasz

Re: Multiple tax ID for same vendor

sunny_talwar — Wed, 23 Aug 2017 11:41:41 GMT

May be like this

Dimension

VendorNum

Tax ID

Expression

If(Count(DISTINCT TOTAL <[Tax ID]> VendorNum) > 1, 1, 0)

And then you can hide the expression from the presentation tab, if you only wish to see the two fields in your straight table chart

Re: Multiple tax ID for same vendor

Anonymous — Wed, 23 Aug 2017 11:54:01 GMT

Thanks, this seems to work fine, just 1 more thing, I have a lot TAX IDs values "No Tax ID" and that's appearing too. How do I remove that from the output?

Re: Multiple tax ID for same vendor

sunny_talwar — Wed, 23 Aug 2017 11:59:18 GMT

May be this

If(Count(DISTINCT {<[Tax ID] -= {'No Tax ID'}>} TOTAL <[Tax ID]> VendorNum) > 1, 1, 0)

If(Count(DISTINCT TOTAL <[Tax ID]> VendorNum) > 1 and [Tax ID] <> 'No Tax ID', 1, 0)

Re: Multiple tax ID for same vendor

Anonymous — Wed, 23 Aug 2017 12:26:53 GMT

Thanks a lot, it works