Micro chart trend

[mayankraoka]

Hi All,

I have a requirement to show micro chart in straight table.In this I have customers and its tier dimension.Customers on the basis of sales divided into tiers.So if customer sales is high tier1 low tier10.

I want 12 month trend view micro chart how that customer tier changes over period of time.

Can anyone help me on this.

Regards,

Mayank

[qliksus]

If  this what you want then use trellis chart

Dimension : Customer,Month

Expression: max(Tier)

Then enable trellis chart to get the below view of how customer is placed in a tier for each month

[mayankraoka]

Hi All,

But I have more than 30 customers which wont look good in trellis.

Regards,

mayank

[mayankraoka]

Hi Miguel,

In this way I am not able to differentiate the tiers.That customers belong to which tier during that month.

Regards,

Mayank

[miguelbraga]

Just add the field [Mes] in your dimensions, that way you'l know

Regards,

MB

[ajsjoshua]

Hi,

PFA

[mayankraoka]

Hi joshua,

Thanks you once again for your quick reply.We are very close to our requirement.We have more than 30 customers so to see 12 months separately for each customer will not solve the issue.Is there any way we can show 12months trend for each customer on 1 row?

Please let me know in case you need any info.

Regards,

Mayank

[qliksus]

Hi,

Are you looking for something like this ?

[mayankraoka]

Hi,

Thanks for the input .Is there any way we can change the colours.I think here we can change colors only for max and min value.How I can differetiate the colurs of dots on the basis of tiers.

This will help users to identify tiers(Numbers) on the basis of colors.Just to differentiate.

Regards,

Mayank

[mayankraoka]

Yes ,I was looking for this only is there any way that they can identify the tier  numbers either colors or something else.