Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Comparing Results of Dimension

Hello,

I have a requirement to have the following chart in a document:

Timescale
TargetLast WeekThis WeekVariance
Sales152010-10





Target, Last Week, This Week, Variance are values of the Dimension Timescale, Sales is an expression to return the values.

This tricky bit is the formatting that is required, I need cells highlighted comparing the results to the target, I'm unsure on how to write the code for a dimension to compare say Last Week to This Week

Any ideas/suggestions?

Regards

Chris

1 Solution

Accepted Solutions
whiteline
Honored Contributor II

Re: Comparing Results of Dimension

Hi.

You can use set analysis to get the result for corresponding dimension values.

sum(total {<Timescale={"1:Target"}>}Sales)

The total is used here to have this value for each Timescale value.

Then you could write an expression for background color for your originall expression (Plus sign to the left of the expression name on expression tab).

2 Replies
whiteline
Honored Contributor II

Re: Comparing Results of Dimension

Hi.

You can use set analysis to get the result for corresponding dimension values.

sum(total {<Timescale={"1:Target"}>}Sales)

The total is used here to have this value for each Timescale value.

Then you could write an expression for background color for your originall expression (Plus sign to the left of the expression name on expression tab).

Not applicable

Re: Comparing Results of Dimension

Thanks... still trying to get my head round set analysis, but your solution is working perfectly.  My first attempts were missing the Total element