topic Re: Need To Get Data from Previous WeekYear In Set Analysis in QlikView

Need To Get Data from Previous WeekYear In Set Analysis

Thu, 10 Jan 2013 08:16:34 GMT

I have a bar chart in which I am counting the number of tickets stacked in 3 phases (Submittal,Analysis,Implementation).

On X axis I am taking customized WeekYear (for eg W252 for year2012 & week52) that is being generated by Calendar script.

On Y axis i am using a set expression for every phase and set expression look like :

count({ReportTypeId={10},

MeasuredPhase={'Submittal'}>} DISTINCT ReportId) {For Submittal similar for other two phases}

User has flexibility to select the WeekYear from a slider.

I am also attaching the image of chart that I am getting for selected range.

My requirement is I want to cretae one more expression in this chart which will show the diffrence of measured week compare to previous week.

For attached chart I want figure on x axis like

Week : W242 W243 W244 W245 W246 W247 ............

Diff : 16 0 -5 -6 3 -16

I want to represent this Diff on x axis below the bars

Kindly suggest the suitable set expression to do this

This is really very urgent

stigchel — Thu, 10 Jan 2013 12:15:23 GMT

Hi,

I think you can use the Above function for this. =Expression-Above(Expression)

See the help for this function, also if you need to use the TOTAL qualifier.

Regards,

Piet Hein

Fri, 11 Jan 2013 04:23:55 GMT

Thanks a lot for this help. It is giving me the right data I required.

But for first dimensional value it is giving Null

For W242 value is coming Null Even I want for this week diff = W242-W241 (Although W241 is not visible on X axis).

Is there any work around or trick to achieve this.

Thanks & Regards

Tribhuwan

stigchel — Fri, 11 Jan 2013 09:02:14 GMT

You could check for the first dimension value, from the help:

if( ColumnNo( )=1, 0, sum( Sales ) / before( sum( Sales )))

An other work around I tested was to make sure that 11 Dimension values existed but to show only ten (properties presentation tab/max visible number)

Fri, 11 Jan 2013 09:37:08 GMT

I am selecting WeekYear from a calendar slider.

Can you please guide how to do this

1. Suppose I have selected W1240 to W1252 on slider and also wanted to show graphs for this selection.

2. How to implement as values are selected from W1239 to W1252 and only graph is visible for W1240 - W1252

Thanks & Regards

Tribhuwan