Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Straight Table Summary

I want to create a table with the following Dimensions:

  • Product Brand
  • Year/Week

My Expression (data being displayed) is:

  • Sum(Qty Affected)

When I create a Straight Table I get basically a list:

Straight Table.jpg

A pivot table works ok, but not the look I want (I don't like WeekYear label):

Pivot Table.jpg

Is there a simple way to create a Straight Table with the dimensions listed above that looks move like this mock up?

Table Chart.jpg

I'll get into asking about conditional colors later.

Thanks

7 Replies
Highlighted
Specialist III
Specialist III

Provide sample data.(data not in pics like above pls)

Highlighted
Creator II
Creator II

Hi Krishna:

I've attached a sample of the data to my post.

Thanks

Jeff

Highlighted
Specialist
Specialist

Hi Jeffry,


In Expression > Background Color write the IF condition.. like show in the image below


Capture.PNG

Highlighted
Creator II
Creator II

Venkata:

That part I know how to do. The condition I want to create is:

  1. If wk2 is is >= 5% higher than wk1, then background is yellow.
  2. If wk2 is is >= 10% higher than wk1, then background is red,
  3. Else background is white

And this will carry on for all of the following weeks (current vs previous)


Thanks


Jeff

Highlighted
Specialist
Specialist

Hi,


You have to write the IF condition on basis of expression. Not on basis of dimension.

Highlighted
Master
Master

Try with if condition for colour coding

Highlighted
Creator II
Creator II

I understand the concept of conditional formatting background based on data expressions.

The hard part is dynamically comparing the cell data from column 1 to column 2;  2 to 3;  3 to 4, etc...

It's not just based on the data in cell by itself.

Am I making sense?

Jeff