topic Re: Subfield and sets in QlikView

Subfield and sets

bernhardiner — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm having problems with using subfields in set expressions. I have a table called T which consists of two columns %KeyT and ValueT.

The data in T looks like this

%KeyT

ValueT

ID1|2016

ID2|2016

...

ID1|2013

ID2|2013

I want to display all the values for ID1. I've tried to use a set expression with a subfield(%KeyT, '|', 1) function to split the %KeyT field and only display ID1-values but that doesn't work. Any ideas on how to do this?

Re: Subfield and sets

suryaa30 — Thu, 07 Sep 2017 16:17:12 GMT

You can use %KeyT as dimension and ValueT in expression. For ValueT use below expression.

only({<%KeyT={"ID1*"}>} ValueT)

Re: Subfield and sets

rohitraut — Thu, 07 Sep 2017 16:20:30 GMT

Hello Henrik,

Try this ,

if(wildmatch( %KeyT,'ID1*'),ValueT)

Re: Subfield and sets

its_anandrjs — Thu, 07 Sep 2017 16:21:03 GMT

In the Calculated dimension try to write one of this that is working

=SubField('ID1|2016', '|',-2)

=SubField('ID1|2016', '|',1)

Re: Subfield and sets

Anil_Babu_Samineni — Thu, 07 Sep 2017 16:26:10 GMT

May be these?

Sum({<%KeyT = {'ID1*'}>} ValueT)

Sum({<%KeyT = P({<%KeyT = {'ID1*'}>} %KeyT)>} ValueT)

Sum(Aggr(If(WildMatch(%KeyT, 'ID1*'), Sum(ValueT)), %KeyT))

Sum({<%KeyT = {"=Match(Left(%KeyT, 3),'ID1')"}>}ValueT)

Re: Subfield and sets

its_anandrjs — Thu, 07 Sep 2017 16:27:03 GMT

There is other ways for this also

Dim:- =If(WildMatch(%KeyT , 'ID1*' , %KeyT)

//Note:- Suppress when value is null selected

Expression:- Sum(ValueT)