topic Set analysis for non number data in QlikView

Set analysis for non number data

Tue, 04 May 2010 11:05:11 GMT

Hi everyone,

I am wonder if there if there is any thing similar to set anaylsis for non-numerical data. E.g. In the data base, which company name (selection list box) link with some notes. And I allow user to select one extra company for data comparsion. For number, I can use set analysis (e.g. sum({$<company = Second_Selection>}Size), etc). But how can I do that for the notes?

To get notes for the "Main" company, the formula is simply "=Notes". How can I show the notes of another company??

Regards,

Ivan

Set analysis for non number data

Tue, 04 May 2010 15:52:18 GMT

Hi Ivan

If you look up the set examples in book III page 355 ff you can see many examples using set for non-numeric fields, e.g.


sum({$-1<Product = {"*Internal*","*Domestic*"}>} Sales)

This will give you the result of the current selection minus the Internal and Domestic Products

Juerg

Set analysis for non number data

Tue, 04 May 2010 16:01:51 GMT

Hi Juerg,

Thanks for your advise. However, all examples use "sum", including your example. Sales are number, therefore, it makes no problem by using "sum" function.

But " notes" are text, same for its content. Therefore, I can use "sum" with set anaylsis.

Regards,

Ivan

Set analysis for non number data

Tue, 04 May 2010 16:22:05 GMT

You want to concat notes then based on the selections?


concat('Notes')
or
aggr(concat('Notes'), <group>)

Set analysis for non number data

Tue, 04 May 2010 16:47:57 GMT

Hi,

Thanks for the suggestion. It works by using concat({Set} distinct Notes)