topic Re: 101 chart question in QlikView

101 chart question

Wed, 14 May 2014 02:20:24 GMT

Apologies in advance for what must be a simply answered question

I have a CSV of deliveries during the month of essential form

Part A delivered May 2

Part A delivered May 6

Part A delivered May 10

Part B delivered May 5

Part C delivered May 6

Part C delivered May 10

Part D delivered May 8

Part E delivered May 3

Part E delivered May 6

Part F delivered May 3

Part F delivered May 9

Part G delivered May 2

Part G delivered May 13

I need a simple chart showing number of occurrences where a part is shipped multiple times a month/period

Occurrences

| X

| X X

| X X X

|----------------------------------------------------------------------------------------------------------------------------------------------

1 2 3 Shipments

Tks Dave

Re: 101 chart question

jagan — Wed, 14 May 2014 03:10:58 GMT

Hi,

Try this script

Data:

LOAD *

Inline [

Part, Occurence

Part A, delivered May 2

Part A, delivered May 6

Part A, delivered May 10

Part B, delivered May 5

Part C, delivered May 6

Part C, delivered May 10

Part D, delivered May 8

Part E, delivered May 3

Part E, delivered May 6

Part F, delivered May 3

Part F, delivered May 9

Part G, delivered May 2

Part G, delivered May 13];

Count:

LOAD

Part,

Count(Occurence) AS Shipments

RESIDENT Data

Group by Part;

Now in chart use Shipments as Dimension and Count(Distinct Part) as expression.

Regards,

jagan.

Re: 101 chart question

Wed, 14 May 2014 04:39:28 GMT

Tks Jagan for such a quick response - yes that works well

Now for a slightly different question.

If I have say 6 months of shipments and I only select the latest 3 months - How would I get a bar chart for that - ie dynamic selection based on month?

Re: 101 chart question

jagan — Wed, 14 May 2014 06:42:54 GMT

Hi,

Try like this

Script:

Data:

LOAD *

Inline [

Part, Occurrence

Part A, delivered May 2

Part A, delivered May 6

Part A, delivered May 10

Part B, delivered May 5

Part C, delivered May 6

Part C, delivered May 10

Part D, delivered May 8

Part E, delivered May 3

Part E, delivered May 6

Part F, delivered May 3

Part F, delivered May 9

Part G, delivered May 2

Part G, delivered May 13];

Chart:

Dimension -> Add Calculated Dimension -> Enter =Aggr(Count(Occurrence), Part)

Expression : =Count(DISTINCT Part)

Hope this helps you.

Regards,

Jagan.

Re: 101 chart question

Wed, 14 May 2014 07:33:38 GMT

Yes - works perfectly - thanks again Jagan