topic Set Analysis Equation in QlikView

Set Analysis Equation

evansabres — Fri, 02 Dec 2016 18:18:48 GMT

I am looking to create a stacked bar chart that shows the following:

Number of projects worked on by an artist. An artist can work on four types of projects (JobType); Print, Digital, Motion or Video

I think I would need to have four separate equations, each referencing the different types of JobTypes.

My initial attempt didn't seem to work.

=NUM(SUM({$JobType={"Print"},}>}JobType)

How do I need to alter this?

sunny_talwar — Fri, 02 Dec 2016 18:22:04 GMT

I think you just need to add JobType as your second dimension and then select stacked style on the style tab

Dimension

Artist

JobType

Expression

Count(JobType)

evansabres — Fri, 02 Dec 2016 18:26:09 GMT

I also tried this and it worked.

=NUM(Count({$<jobsJobTypeID={"1"},}>}jobsJobTypeID),'#,###.')