topic Re: Micro chart trend in QlikView

Micro chart trend

mayankraoka — Thu, 05 May 2016 03:44:55 GMT

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

Re: Micro chart trend

ajsjoshua — Thu, 05 May 2016 04:49:50 GMT

Hi,

=aggr(if(

sum({<[tier]={"high tier"} >}sales)

, 1),customers) & aggr(if(

sum({<[tier]={"low tier"} >}sales)

, 10),customers)

Regards,

Joshua.

Re: Micro chart trend

mayankraoka — Thu, 05 May 2016 07:44:51 GMT

Hi Joshua,

I have a bit tricky requirement here.Do we have any extension that shows value of micro chart.In this we need to show that customers movement in tiers.For example:In jan month they are tier1 and feb tier2 and Mar tier7,So basic idea is to show at that month customers is in which tier.We have readily available separate tier column against customers.

Please let me know in case you need any other information.

Regards,

Mayank

Re: Micro chart trend

mayankraoka — Thu, 05 May 2016 07:45:11 GMT

Hi Joshua,

Please let me know in case you need any other information.

Regards,

Mayank

Re: Micro chart trend

mayankraoka — Thu, 05 May 2016 08:48:05 GMT

Can any one suggest on this.

Re: Micro chart trend

ajsjoshua — Thu, 05 May 2016 09:44:23 GMT

Hi,

could u pls provide me some sample excel files

Re: Micro chart trend

mayankraoka — Thu, 05 May 2016 10:57:49 GMT

CUSTOMER NAME	time	Tier
Customer1	01-01-2015	2
Customer1	01-02-2015	1
Customer1	01-03-2015	4
Customer1	01-04-2015	3
Customer1	01-05-2015	5
Customer1	01-06-2015	3
Customer1	01-07-2015	4
Customer1	01-08-2015	4
Customer1	01-09-2015	3
Customer1	01-10-2015	4
Customer1	01-11-2015	6
Customer1	01-12-2015	7
Customer2	01-01-2015	3
Customer2	01-02-2015	4
Customer2	01-03-2015	4
Customer2	01-04-2015	4
Customer2	01-05-2015	5
Customer2	01-06-2015	6
Customer2	01-07-2015	2
Customer2	01-08-2015	1
Customer2	01-09-2015	1
Customer2	01-10-2015	1
Customer2	01-11-2015	1
Customer2	01-12-2015	1
Customer3	01-01-2015	6
Customer3	01-02-2015	4
Customer3	01-03-2015	2
Customer3	01-04-2015	7
Customer3	01-05-2015	2
Customer3	01-06-2015	4
Customer3	01-07-2015	2
Customer3	01-08-2015	2
Customer3	01-09-2015	1
Customer3	01-10-2015	1
Customer3	01-11-2015	1
Customer3	01-12-2015	1

Here is the sample data:

Regards,

mayank

Re: Micro chart trend

qliksus — Thu, 05 May 2016 11:32:27 GMT

I am not sure I have understood your requirement completely but in the straight table

you can take Dimension : Customer , Tier

Expression : You can have the mini chart setting for Month

If possible you can post some required O/P how you want the display to be ?

Re: Micro chart trend

miguelbraga — Thu, 05 May 2016 11:33:41 GMT

Check this out, please

Regards,

Re: Micro chart trend

miguelbraga — Thu, 05 May 2016 11:40:02 GMT

Or maybe this.

Thank me later

Re: Micro chart trend

qliksus — Thu, 05 May 2016 11:52:03 GMT

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

Re: Micro chart trend

mayankraoka — Thu, 05 May 2016 14:11:15 GMT

Hi All,

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

Regards,

mayank

Re: Micro chart trend

mayankraoka — Thu, 05 May 2016 14:13:09 GMT

Hi Miguel,

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

Regards,

Mayank

Re: Micro chart trend

miguelbraga — Thu, 05 May 2016 14:40:19 GMT

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

Regards,

Re: Micro chart trend

ajsjoshua — Fri, 06 May 2016 04:53:09 GMT

Hi,

PFA

Re: Micro chart trend

mayankraoka — Fri, 06 May 2016 07:06:12 GMT

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

Re: Micro chart trend

qliksus — Fri, 06 May 2016 07:36:52 GMT

Hi,

Are you looking for something like this ?

Re: Micro chart trend

mayankraoka — Fri, 06 May 2016 07:53:49 GMT

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

Re: Micro chart trend

mayankraoka — Fri, 06 May 2016 09:10:17 GMT

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