Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

First Sorted Value Expression Prob

Hey,

I am using an expression:

=$(=FirstSortedValue('[' & $(vDim) & ']' , _DimPosition , 1))

where vDim = subfield(_Dim , ':' , -1) and _DimPosition has numerical values from 1 to 28.

With ENable condition true with expression:

Getselectedcount(_Dim) >= 1 ;


Now , i dont understand what does BOTH above expression means and what does they returns ?

THanks

12 Replies
nikhilgarg
Specialist II
Specialist II
Author

Yeah actually all three enable condition is assigned to 3 different Calculated Dimension. Thanks i wanted to clear this doubt. And if i am not wrong if i select 3 dimension then all three enable condition and calculated dimension are executed to get 1st , 2nd and 3rd dimension as per _DimPosition field  . For eg:

If i select dimension at pos 12 , 34 and 8 then final straight table contain columns starting with dim 8, 12 and 34 position. Is it ??

rubenmarin

I'll need to check a sample to be sure, but that's what I understand it does.

nikhilgarg
Specialist II
Specialist II
Author

Ohk but in case if you create sample and observer then let me know. Thankx