topic Re: Fix a field value in table in qliksense in App Development

Fix a field value in table in qliksense

sanjujeeboy — Sat, 16 Nov 2024 03:32:00 GMT

I have field called Manufacturer which has 10 value. I want to display top 5 manufacturer with highest sales.

Note: i want to always display One of the Manufacturer say 'A' even when its not in top 5.

how to achieve this?

Thanks

anushree1 — Mon, 20 Jan 2020 07:02:21 GMT

You could try the below:

if(Manufacturer='A', Sum(Sales),if(rank(sum(Sales))<=5,Sum(Sales)))

If it does'nt work, suggest you to please share the sample, so that the expression precise to your requirement could be arrived at

sanjujeeboy — Mon, 20 Jan 2020 08:44:35 GMT

when sales sorted in decreasing order, If Manufacturer A is present in Top 5 , then display as it is,

if Manufacturer A not present in top 5 then display Top 5 as well as Manufacturer A numbers

Thanks.

anushree1 — Mon, 20 Jan 2020 09:49:06 GMT

The Expression Shared before works in this case,

Please check the attached

sanjujeeboy — Mon, 20 Jan 2020 12:09:05 GMT

with reference to qvf you have shared,can you show the output in 1st table itself instead of creating two tables.

sanjujeeboy — Mon, 20 Jan 2020 12:16:19 GMT

This solution worked.

Thanks.