Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

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).

View solution in original post

2 Replies
whiteline
Master II
Master II

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).

View solution in original post

Not applicable
Author

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