Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

Set analysis problem with value formats

I have an urgent  problem with set anlayis. I have to monitor price changes and need to know for how long the lowes/highest price was valid. I build some test case and it works fine for numbers without digits but not for numbers with digits nor for my real data.

Example:

2011-08-16 001.jpg

With the Basic price the following works fine (in words: search the min.date for the min.Price):

=min( {$<(Basic.Price = { $(=min(Basic.Price)) }> } Date )&' - '&max( { $<Basic.Price = { $(=min(Basic.Price)) }> } Date )

2011-08-16 002.jpg

However, with numbers with digits it does not work:

2011-08-16 003.jpg

The function min(Price) gives back the correct value of 2,12 but this as input for the selection in the SET seems to be a problem....

I attached the example QV-file.

Any ideas ?

Christian

1 Solution

Accepted Solutions
MVP
MVP

Re: Set analysis problem with value formats

Hi,

I think the returned comma of min(Price) is problematic and the set element expression should use '' like

=min( { $<Price = {'$(=min(Price))'}> } Date )

&' - '&

max( { $<Price = {'$(=min(Price))'}> } Date )

(Note that I guarded the dollar sign expression with ' '. That way it works for me.

Stefan

5 Replies
MVP
MVP

Re: Set analysis problem with value formats

Hi,

I think the returned comma of min(Price) is problematic and the set element expression should use '' like

=min( { $<Price = {'$(=min(Price))'}> } Date )

&' - '&

max( { $<Price = {'$(=min(Price))'}> } Date )

(Note that I guarded the dollar sign expression with ' '. That way it works for me.

Stefan

hkg_qlik
Contributor III

Re: Set analysis problem with value formats

Hi Christian,

Please find the attached solution for the issue.

Please note:

=min( { $<Price = { '$(=min(Price))' }> } Date )

&' - '&

max( { $<Price = { '$(=min(Price))' }> } Date )

Let me know if this solves your issue.

Regards,

H

Not applicable

Re: Set analysis problem with value formats

Thank you both, this works for my example. No I realize the next issue:

When I add a second product (field MP has now >1 value) the set-analysis ignores this dimension in the chart-table. As a result I find the only the date when the minPrice is the absolute min, not the min for the product.

2011-08-176 001.jpg

How to take into account the dimension ?

(Attached an updated example)

MVP
MVP

Re: Set analysis problem with value formats

Hi,

I believe what you want to achieve is quite hard using set analysis, if possible at all.

But using advanced aggregation, it's possible.

Please have a look at my attached sample.

Regards,

Stefan

Not applicable

Re: Set analysis problem with value formats

Hi Stefan,

thank you very much !!

This completely solves the problem (even if the aggr-function took a bit longer to understand...)

Let's hope, that QV implements a set analysis also interpreting the chart dimension as per line selection to be added to the set-analysis selection in a future version...

Again, thank you

Christian