topic Re: How to display possible values within a straight table.? in QlikView

How to display possible values within a straight table.?

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

Hi All,

I am creating a straight table that identifies customers who purchased products via specific discount codes.

So one of the expressions in my straight table should display all discount codes of a customer with comma in between.

eg the field should show as "DA,DB,DC".

Cust No	Cust Name	Year	Month	Sales Value	Qty	Discount Codes
1	Cust1	2017	May	1000	10	AS,DA,DC
2	Cust2	2017	May	5000	35	GA,GB,DC

Is there a simple way of achieving this?

Thanks and regards,

Sneha

Re: How to display possible values within a straight table.?

kaushiknsolanki — Wed, 28 Jun 2017 10:58:17 GMT

You Can use the concate() function to get the comma separated values.

Regards,

Kaushik Solanki

Re: How to display possible values within a straight table.?

snehamahaveer — Wed, 28 Jun 2017 11:02:41 GMT

Hi Kaushik,

Thank you.

I have over 100m lines of invoice and over 50 to 60 discount codes. The expression should identify the possible discount codes for the specific customer and display them.

I am not sure how Concat() would help with such a situation. Can you please explain.

Many thanks,

Re: How to display possible values within a straight table.?

kaushiknsolanki — Wed, 28 Jun 2017 11:04:47 GMT

Do you want to show all the discount codes of all the transactions against each transactions?

If yes then using the Concate() will be the best option in chart.

You will need to write the expression using the Total Keyword to get the possible codes for a customer.

Regards,

Kaushik Solanki

Re: How to display possible values within a straight table.?

tresB — Wed, 28 Jun 2017 11:05:12 GMT

Have you tried like : Concat( Distinct [Discount Codes], ',') ?

Re: How to display possible values within a straight table.?

snehamahaveer — Wed, 28 Jun 2017 11:12:06 GMT

Thank you so much for the prompt help