Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using visual cues in pivot table

Hi,

I need to color the concepts in green which have green background for two consecutive columns (Ex: Headlamps)

and need to color the concepts in red which have red color font for two consecutive columns. (Ex: shutter speed, disk partitioning)

I have attached the pivot table, the dimensions, the expression used and the visual cues used.

Thanks in advance!

Untitled.png

23 Replies
Not applicable
Author

IF(Previous(Concept)=Concept, 'NO', 'YES') as NewConcept

This is how a new concept is defined.

Basically I want to study/identify which concepts have sustained over time/ which concepts have died out based on the difference in the counts of those counts.

saumyashah90
Specialist
Specialist

What you can do is

you have +Concept in the dimension

Click on the + sign ,you will get  3-4 option under it,

Click on background  and write a expression under it

if([Incremental Change in Concepts]>0,Green(),Red());

Not applicable
Author

Hi Saumya,

But incremental change in concept for the whole dimension will not make sense right ?

if((Sum(Count_Concepts))-(Before(Sum(Count_Concepts)))>0,Green(),Red())

Because the variable incremental change in concepts has the function BEFORE in it. Which is dependent on the columns of the pivot.

Kindly let know if I need to provide additional data.

Not applicable
Author

Here is the qvw with restricted data.

Kindly post the answer as a  screenshot or in text. As I use a personal edition which cannot open other qvws.

saumyashah90
Specialist
Specialist

See i can see you have different months column.

for each you have different values
1)So either you can take the latest month and show that background in concept

or

2)Take the average of all and den show it,you need to think over it.

saumyashah90
Specialist
Specialist

and about the dimension thing,Yes you need to take it as a dimension if you are using it

Not applicable
Author

Hi Saumya,

I understand that part but my requirement is not just the last month and also taking the average wont suffice.

I need to figure out those concepts which have incrementally grown over time. Which means identifying those concepts that have green fields across consecutive months.

And the converse is required to identify the concepts which have declined over time.

Not applicable
Author

Putting the same question in general QV users sense.

Identifying customers who've bought stuff in an increasing rate throughout the time frame considered.

and identifying the customers who've reduced purchase consistently over the time frame considered.

saumyashah90
Specialist
Specialist

Okay there is one more question for this then,

What if it is 1in Oct,-4 in Nov,2 in Dec and -3 in Jan

So how you want to  show background of the concept.

GoodOption would be.

You can check previous month and latest month ( If it has grown show green or else red)