Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Help on displaying data

Hi gurus,

I am preparing some statistical report and able to display the data using text box object. I would like to know if it is possible to display the data using straight table or pivot table and how to decide on dimensions. My data looks like this:

Raw Data:

Trade DateTrade ValueTrade Volume
02/15/201156789723456
02/20/201176992734567
03/10/2011890000038921
04/05/20115345839512324
04/23/20119469769035348539

Display required:

Apr 2011March 2011% change
Trade Value<sum of trade value in apr><sum of trade value in mar>change between apr and march trade value
Trade Volume<sum of trade volume in apr><sum of trade volume in mar>change betweeapr and march
1 Solution

Accepted Solutions
jason_michaelid
Honored Contributor II

Re: Help on displaying data

(Oops - I got the 2 labels mixed up! Switch them around...)

3 Replies
jason_michaelid
Honored Contributor II

Re: Help on displaying data

I'm going to assume that you only ever want to see two months' variations, but that you may select different months as a start point...

In your script:

Data:

CrossTable(MeasureType,Amount,3)

LOAD

Date,

MonthStart(Date) AS MonthStart,

MonthEnd(Date) AS MonthEnd,

TradeVolume,

TradeValue

From...your data source...;

Then, in your straight table chart, use MeasureType as the dimension and add 3 expressions:

Sum({<Date = {"<=$(Max(MonthEnd)) >=$(Max(MonthStart))"}>} Amount) As your label, use =Date(AddMonths(Max(MonthStart),-1),'MMM YYYY')

Sum({<Date = {"<=$(=AddMonths(Max(MonthEnd)),-1) >=$(=AddMonths(Max(MonthStart)),-1)"}>} Amount) As your label, use =Date(Max(MonthStart),'MMM YYYY')

Column(1)-Column(2)

That should work if I've got the syntax right...

Hope this helps,

Jason

jason_michaelid
Honored Contributor II

Re: Help on displaying data

(Oops - I got the 2 labels mixed up! Switch them around...)

Not applicable

Re: Help on displaying data

Thanks, Jason it worked for me.

Community Browser