Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

explination?


substringcount(concat(%dim3,'|'),fullname) and get selectedcount(%dim3)<>0

here what it do ? i know work functionality of concat but here quite different what it do here?

1 Solution

Accepted Solutions
ashfaq_haseeb
Champion III
Champion III

Hi,

Part 1

substringcount(concat(%dim3,'|'),fullname)

To count with or without any selection


Part 2

getselectedcount(%dim3)<>0

To count for Selection, This condition here means there must be some selected values


Hope it helps

Regards

ASHFAQ


View solution in original post

7 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Yhe first expression count how many "fullname" there are in the string composed by %dim3 while the second expresion count how many values you have selected in field %dim3

Not applicable
Author

it means how many full names are there in the  %Dim3  or  in the string  selections of %Dim3

its_anandrjs

First one counts the full names while second one that is getselectedcount(%dim3)<>0 is a condition which checks how many value selected in the %dim3. And it is worked only where there is some value selected in the field %dim3 at least one value.

Regards

Anand

alexandros17
Partner - Champion III
Partner - Champion III

The first expression (Used in a object,  not in the script) returns all the values for selected field depending on the expresion, so the result can be different from the second expression

Not applicable
Author

it counts the no of full names in %dim3  ? OR selections of %dim3  pls tell me

Not applicable
Author

If you will select anything for %dim3, then it work work over that select set of data, otherwise if nothing is selected it will traverse over all values of %dim3.

Hope this was helpful.

Thanks,

Singh

ashfaq_haseeb
Champion III
Champion III

Hi,

Part 1

substringcount(concat(%dim3,'|'),fullname)

To count with or without any selection


Part 2

getselectedcount(%dim3)<>0

To count for Selection, This condition here means there must be some selected values


Hope it helps

Regards

ASHFAQ