topic Re: Straight Table Summary in QlikView

Straight Table Summary

jmonroe918 — Wed, 25 Nov 2020 16:16:04 GMT

I want to create a table with the following Dimensions:

My Expression (data being displayed) is:

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

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

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

I'll get into asking about conditional colors later.

Thanks

Qrishna — Thu, 08 Mar 2018 01:40:10 GMT

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

jmonroe918 — Thu, 08 Mar 2018 14:47:29 GMT

Hi Krishna:

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

Thanks

Jeff

Anonymous — Thu, 08 Mar 2018 15:10:35 GMT

Hi Jeffry,

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

jmonroe918 — Thu, 08 Mar 2018 15:34:03 GMT

Venkata:

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

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

Thanks

Jeff

Anonymous — Thu, 08 Mar 2018 16:44:15 GMT

Hi,

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

shiveshsingh — Thu, 08 Mar 2018 17:06:35 GMT

Try with if condition for colour coding

jmonroe918 — Thu, 08 Mar 2018 17:16:09 GMT

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