topic Re: explination? in QlikView

explination?

Mon, 27 Oct 2014 07:40:38 GMT

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?

Re: explination?

alexandros17 — Mon, 27 Oct 2014 07:43:56 GMT

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

Re: explination?

Mon, 27 Oct 2014 07:49:07 GMT

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

Re: explination?

its_anandrjs — Mon, 27 Oct 2014 07:52:39 GMT

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

Re: explination?

alexandros17 — Mon, 27 Oct 2014 07:53:28 GMT

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

Re: explination?

Mon, 27 Oct 2014 08:02:05 GMT

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

Re: explination?

Mon, 27 Oct 2014 08:05:58 GMT

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

Re: explination?

ashfaq_haseeb — Mon, 27 Oct 2014 08:06:59 GMT

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