Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

First day of using QlikView Personal and running into problems

I am trying to get to grips with QlikView Personal to simplify some monthly reports that I run.

The report I am trying to generate is for our Monthly Sales Report by Salesman.  I have a spreadsheet with all the Account Numbers against the Salesman Names, and have edited the connection in QlikView to connect to the SQL Database where the invoice information is stored.

I have managed to bring up the data into a table, but would like to pre-format the table as follows:

Month         Jan      Feb      Mar      Apr     May     Jun     etc

Salesman1

Salesman2

etc

I would like to then have a drop down to select the year to show their turnover, and then create a linked chart to show the Customers allocated to a chosen salesman and how they make up the monthly figure

I have the table almost complete, but no idea on how to merge down the months instead of showing separate dates?

Can anyone help a novice out on this please?

Many thanks in advance

Peter

1 Reply
er_mohit
Honored Contributor II

Re: First day of using QlikView Personal and running into problems

Try this crosstable concept

CrossTable(month,values)

LOAD year,

     jan,

     feb,

     march,

     apirl,

     may,

     june,

     july

FROM

(ooxml, embedded labels, table is Sheet1);

Community Browser