Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Why Comparative Analysis - Technical Brief.pdf

cancel
Showing results for 
Search instead for 
Did you mean: 
sna
Partner - Contributor III
Partner - Contributor III

Why Comparative Analysis - Technical Brief.pdf

Attachments

Comparative Analysis is one of the uniqueness of QlikView.  It is a way to analyze data based on sets of multiple values (group comparison).   It is not a comparison between two items such as Company A vs Company B.  It is all about you, the user, creating customized groups on demand. 

Learn what comparative analysis is all about and how you can set it in your application.  This technical brief includes step-by-step instructions.

Here is a recording of how Comparative Analysis works. 

See my blog post on this topic also.

Shima

Comments
bill_markham
Champion III
Champion III

Shima

Brilliant pdf, many thanks.

On page 8 though you have expression.

  • Avg({[Group 1]<[Year] = $::[Year], [Month] = $::[Month]>} [Adj. Close])

What does the $:: do ?

I have tried searching for it, but I think the non proper word / characters messes up the search.

Best Regards,     Bill

0 Likes
sna
Partner - Contributor III
Partner - Contributor III

Hi Bill,

When you use an alternate state, it ignores the "default" data association, and it defines its own data model (a copy of the default one).  However, if you'd like to reuse the "default" data association such as Year, Month or any other common fields, then you can use them for the alternate state groups by using $::. 

Let's say I have Group A as an alternate state. If I want to use a field called Year in a list box, then I will need to create a new list box for "Year" and set the alternate state to be "Group A".  Instead, if I want to have the "Year" field from other sheets (default) to carry over to my alternate state group "Group A", then I can still use the default "Year" field list box to apply to my "Group A" by using "$::".  Otherwise, the default Year field would not affect your expression of "Group A".  It is simply ignored.

I hope this helps!

Shima

JoaquinLazaro
Partner - Specialist II
Partner - Specialist II

Hi Shima:

Great job.

Soon I will prepare a qvw with Alternate States. Thank you

0 Likes
valerio_fatatis
Partner - Contributor III
Partner - Contributor III

A very good document.

thnanks for share

0 Likes
Version history
Last update:
‎2013-02-26 01:03 PM
Updated by:
Partner - Contributor III