Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikers,
It is quite simple but m getting confuse for this in scripts. I want to exclude max value product (D) from my list to show in straight table, I am extracting below data from excel sheet.
PRODUCT | Value |
A | 10 |
C | 20 |
D | 30 |
E | 40 |
E | 50 |
D | 90 |
Expected output :
PRODUCT | Value |
A | 10 |
C | 20 |
E | 40 |
E | 50 |
Thanks
This?
T1: Load * Inline [ PRODUCT, Value A, 10 C, 20 D, 30 E, 40 E, 50 D, 90]; Load FirstSortedValue(PRODUCT, -Value) as MaxPROD Resident T1 ; T2: NoConcatenate
Load * Resident T1 Where Not Exists(MaxPROD,PRODUCT); Drop Table T1; Drop Field MaxPROD;
Max in aggregate or in individual value?
Individual value.
If possible let me know both.
This?
T1: Load * Inline [ PRODUCT, Value A, 10 C, 20 D, 30 E, 40 E, 50 D, 90]; Load FirstSortedValue(PRODUCT, -Value) as MaxPROD Resident T1 ; T2: NoConcatenate
Load * Resident T1 Where Not Exists(MaxPROD,PRODUCT); Drop Table T1; Drop Field MaxPROD;
Hi Shubham,
You can acheive the same from UI a well, using the same logic mentioned by tressesco.
Ref attached.
I got:
Try like this:
T1:
Load RowNo() as Si,
PRODUCT,
Value;
Load * Inline [
PRODUCT, Value
A, 10
C, 20
D, 30
E, 40
E, 50
D, 90];
In UI: Create a straight chart:
Dim1: Si
Dim2. =if(PRODUCT<>FirstSortedValue(total PRODUCT, -Value),PRODUCT)
expression:Sum(Value)
You can hide Si field from presentation tab:
Thanks @jyothish8807 , working absolutely fine but I want to do it in script.
@tresesco , it is working for table box but when I am taking PRODUCT as dimension in straight table it is not showing 'E'.