topic Re: giving out a certain number of values in QlikView

giving out a certain number of values

thanhphongle — Wed, 02 Mar 2016 11:46:37 GMT

Hello Community,

I created a textbox which returns me the max price of my products

this is my database

Product	Price
A	1000
B	500
C	100
D	1000
E	1000
F	600
G	1000
H	1000
I	1000

this is my expression:

='Max Price ' & '\n' &

Concat(DISTINCT {<Product = {"=Aggr(max(Price), Product) = Max(TOTAL Aggr(max(Price), Product))"}>} Product, ', ') & ' ...' & '\n '

& money(Max(TOTAL Aggr(Max([Price]),Product )))

QV returns me:

Product	Price
A	1000
D	1000
E	1000
G	1000
H	1000
I	1000

This is definetly correct.

But what I want is, that QV should return me max 3 values. Something like:

A = 1000

D = 1000

E = 1000 etc. ...

is this possible?

Re: giving out a certain number of values

sunny_talwar — Wed, 02 Mar 2016 11:48:18 GMT

Max 3 values? Not sure I understand completely?

Re: giving out a certain number of values

Chanty4u — Wed, 02 Mar 2016 11:50:14 GMT

try this

=Max(field,3)

Re: giving out a certain number of values

Anonymous — Wed, 02 Mar 2016 11:54:07 GMT

what condition you want to follow as 6 products have proce of 1000?

by alphabetic?

did you look at tab dimension Limits?

Re: giving out a certain number of values

Joaquin_Lazaro — Wed, 02 Mar 2016 11:55:11 GMT

Hi:

Open the properties window of your straight table and set up this dimension limits

Hope it helps

Joaquín

Re: giving out a certain number of values

thanhphongle — Wed, 02 Mar 2016 12:13:46 GMT

I didnt create the expression in a chart. I use this expression in the textbox.

Re: giving out a certain number of values

Anonymous — Wed, 02 Mar 2016 12:20:48 GMT

nevertheless look at source data

create tablebox or listboxes to checkthe origin data

or provide a sample qvw so we can have a look into

Re: giving out a certain number of values

thanhphongle — Wed, 02 Mar 2016 12:22:56 GMT

I attached a qvw file !

3 largest product in alphabetic order would be great

Re: giving out a certain number of values

Joaquin_Lazaro — Wed, 02 Mar 2016 12:29:07 GMT

Here you have it

Re: giving out a certain number of values

thanhphongle — Wed, 02 Mar 2016 12:35:42 GMT

Sry maybe i didnt explain my problem correctly

QV should return Max Price = 1000 and the correspondending products (3, not all) = A, D, E ...

Re: giving out a certain number of values

Joaquin_Lazaro — Wed, 02 Mar 2016 12:38:44 GMT

OK.

Why A,D,E and not G,H,I ?

Do you want a table ?

Re: giving out a certain number of values

sunny_talwar — Wed, 02 Mar 2016 12:40:43 GMT

You can try this:

='Max Price ' & '\n' &

FirstSortedValue(Product, -Aggr(Max(Price), Product) + Ord(Left(Product, 1))) & ' ,' &

FirstSortedValue(Product, -Aggr(Max(Price), Product) + Ord(Left(Product, 1)), 2) & ' ,' &

FirstSortedValue(Product, -Aggr(Max(Price), Product) + Ord(Left(Product, 1)), 3) & ' ,'

& ' ...' & '\n '

& money(Max(TOTAL Aggr(Max([Price]),Product )))

Re: giving out a certain number of values

thanhphongle — Wed, 02 Mar 2016 12:45:13 GMT

I dont actually care if its A, D, E or G, H ,I. I wrote it in the alphabatic order. I dont want a table, it just should return the max price and 3 corrospondending products

Re: giving out a certain number of values

thanhphongle — Wed, 02 Mar 2016 12:45:28 GMT

its . working ! thank you !

Re: giving out a certain number of values

Joaquin_Lazaro — Wed, 02 Mar 2016 12:47:51 GMT

Great thanhphongle

Hope I helped you

Re: giving out a certain number of values

sfatoux72 — Wed, 02 Mar 2016 13:27:47 GMT

You could try this expression too:

I removed all your aggr that are not necessary

='Max Price ' & '\n' &

Left(Concat(DISTINCT {<Price = {$(=max(Price))}>} Product, ', '),Index(Concat(DISTINCT {<Price = {$(=max(Price))}>} Product, ', '), ', ', 3))

& ' ...' & '\n '

& money(Max([Price]))