topic Use Table from Script in Graph in QlikView

Use Table from Script in Graph

Fri, 01 Jun 2012 18:59:23 GMT

I have a script that cretaes 4 tables, top 10 Customers by Week/Month/Quarter/Year. All 4 talbes have the same columns except the time column, just difrent sets of data.

The script also pulls back a table of full detail.

When I go to create the graph Qlick view is using the customer names from the full detail table, not the top 10 from the Week table. How do I get the graph to use the correct table?

Jim

Use Table from Script in Graph

Oleg_Troyansky — Fri, 01 Jun 2012 23:01:54 GMT

Jim,

QlikView charts don't operate with tables. Instead, they operate with fields and field associations. If the same Customer field is used in multiple tables, QlikView will use the field and the any associated data from those tables.

In your example, if you use your "Weekly Top 10" field in any of your expressions (for example, sum of Weekly top 10 Sales, etc...), QlikView will only show those Customers that have any corresponding values.

On the other side, let me ask you why did you feel the need in pre-calculating the top 10 weekly, monthly, quarterly and yearly? QlikView could calculate those things on the fly, eliminating the need in multiple tables in the first place... Granted, those expressions are a bit more complex, but this is the more appropriate way of calculating "top 10" in QlikView

cheers,

Oleg

Use Table from Script in Graph

Mon, 04 Jun 2012 13:34:35 GMT

I am starting to see the value in letting qlikview deal with this. I have set up a chart using the full data set, and using filters I am drilling down to the year/quarter/month/week level data. My question is how do I make qlikView only show me the top 10 customers from all the data?

Use Table from Script in Graph

Oleg_Troyansky — Mon, 04 Jun 2012 15:45:06 GMT

There is a number of ways... The easiest is to sort your Straight table by the descending value and to limit the number of dimension values to only 10 - this is done on the "Presentation" tab.

Use Table from Script in Graph

Mon, 04 Jun 2012 15:58:07 GMT

That is exactly what I did.