Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Master II
Master II

Try this crosstable concept

CrossTable(month,values)

LOAD year,

     jan,

     feb,

     march,

     apirl,

     may,

     june,

     july

FROM

(ooxml, embedded labels, table is Sheet1);