topic Re: Set analysis in Text Object for string in QlikView

Set analysis in Text Object for string

Tue, 31 Mar 2015 12:02:03 GMT

Hello,

I would like to know if it is possible to use a set analysis restriction in a text object but without any expression.

In another words: usually the set analysis is made with a expression like: count, max, aggr, sum, etc and the respective restrictions.

I want to use a set analysis without the expression because I want to show a string and not a value, but I need the restrictions that a set analysis provides me.

Any thoughts?

Thank you.

Best regards.

Ivo Marques

Re: Set analysis in Text Object for string

MK_QSL — Tue, 31 Mar 2015 12:07:33 GMT

You can use.... FirstSortedValue in combination of Aggr and Set Analysis to achieve this..

Provide sample data.

Re: Set analysis in Text Object for string

Anonymous — Tue, 31 Mar 2015 12:08:52 GMT

you may use max or only in combination with your string

Re: Set analysis in Text Object for string

Tue, 31 Mar 2015 12:14:17 GMT

I have the following:

=max({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} Description)

And the value 'Description' is a string.

This comes from a sql query and has many different strings, but with the restrictions I have the is only one string that should appear on the text object.

Re: Set analysis in Text Object for string

MK_QSL — Tue, 31 Mar 2015 12:21:18 GMT

=maxstring({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} Description)

Re: Set analysis in Text Object for string

Tue, 31 Mar 2015 12:31:50 GMT

This returns in fact the max string but without obeying the the restrictions.

Just the max string of the entire universe of 'Description'

Re: Set analysis in Text Object for string

MK_QSL — Tue, 31 Mar 2015 12:34:53 GMT

=Concat({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} Description,', ')

Re: Set analysis in Text Object for string

Anonymous — Tue, 31 Mar 2015 12:43:25 GMT

Maxstring() works with set analysis. Something's wrong with your set.

Re: Set analysis in Text Object for string

Tue, 31 Mar 2015 12:56:40 GMT

Yes it is.

My bad, I caught the problem with my set, but now I don't know how to fix it.

In the set can I use mid(KNR,3,1)={'7'}?

=maxstring({<TestArea={'ASD'},mid(KNR,3,1)={'7'},Description-={'Not valid values:'},Results-={'0'}>} Description)

Re: Set analysis in Text Object for string

Anonymous — Tue, 31 Mar 2015 13:03:48 GMT

No, you can't. It is always a field on the left side. Maybe something like

Field = {" =mid(KNR,3,1)='7' "}

or even remove it from set:

=maxstring({<TestArea={'ASD'},Description-={'Not valid values:'},Results-={'0'}>} if(mid(KNR,3,1)=7, Description))

Re: Set analysis in Text Object for string

stigchel — Tue, 31 Mar 2015 13:04:20 GMT

No, but you can use a search string e.g.

Sum({<Customer={"=Mid(Customer,1,1)='A'"}>} Sales)

in your example

=maxstring({<TestArea={'ASD'},KNR={"=mid(KNR,3,1)='7'"},Description-={'Not valid values:'},Results-={'0'}>} Description)