Showing Tables values

Wed, 27 Feb 2013 11:14:27 GMT

Hello,

I need some help concerning some calculated values.

Basically, I read from a File

IMPORT_ALL_VALUES;

LOAD

FROM MYEXCEL.xlsm (ooxml, no labels, table is [Sheet])

---

TAB_REDUCED:

LOAD

[Date raised],

Application,

RESIDENT IMPORT_ALL_VALUES;

TAB_DEFECT_STATUS:

LOAD * INLINE [

Status

Daily Closed

Daily Opened

Cumul Closed

Cumul Opened

];

TAB_REDUCED_VAL:

LOAD

[Date raised],

Application,

[Current State]

RESIDENT IMPORT_ALL_SIRE;

[Current State] tells me if an application is opened or closed.

Now I can read from TAB_REDUCED all values, but I want to do a COUNT() to check how often an Application has occured for a certain [Date raised] and to add a fields Current State that contains "Daily Closed", "Daily Opened", "Total Closed", "Total Open"

Result should something like:

DATE ¦ Application ¦ Current State ¦ Values

27/02 Test Daily Closed 2

27/02 Test Daily Opened 0

27/02 Test Total Closed 14

27/02 Test Total Opened 12

27/02 Test Daily Closed 0

27/02 Test Daily Opened 0

27/02 Test Total Closed 16

27/02 Test Total Opened 12

I thought about Set Analysis in Expression, but I don't know how the expression could look like.

So far, I managed to gather Application and Current State together, but I don't know how to show the Date and the calculated values in a Chart.

Re: Showing Tables values

Wed, 10 Apr 2013 14:29:54 GMT

Found a solution.

topic Showing Tables values in QlikView

Showing Tables values

Re: Showing Tables values