Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
QStaquet
Contributor
Contributor

Show column if only distinct values

Hi,

I have a table in my application where I don't want to show a column if I have duplicate values, but where I do want to show them if these values are different. I have created a simple example below.

The fields Depot country, Material Group and Price will always show

QStaquet_0-1673534550080.png

Now if we select only DE, I would like to see the table including customer without material. Because for different customers, we have different prices. But all the prices of all materials within one group are the same.

QStaquet_1-1673534955538.png

If we select BE, I would like to see the material, because we have different prices for the materials within one material group.

QStaquet_2-1673535103091.png

 

I tried with putting this formula in the 'show column if'. But only seems to work for the customer and not for the material or both.

avg(aggr(Count(Distinct Price),[Depot country],Material, [Material group]))
>
1

Would you have any idea if this is possible to solve?

Many thanks in advance,

Labels (2)
0 Replies