topic closing opening in QlikView

closing opening

Mon, 27 May 2013 11:50:07 GMT

Dear friends

i have following senario that is

month opening closing

apr 100 200

may 200 500

jun 300 700

july 250 850

so if i selet one month it should show one month opening and closing

if i select apr may jun it should show apr month opening and july month closing dynamically

any idea please share

Re: closing opening

Gysbert_Wassenaar — Mon, 27 May 2013 11:58:18 GMT

Your data needs to be ordered by month. Ideally you'd have a date field. In the example the data is already ordered by month so I add a row field so I have a numeric field to use to find the first and last month of the selection.

Data:

LOAD *, recno() as row INLINE [

month, opening, closing

apr, 100, 200

may, 200, 500

jun, 300, 700

july, 250, 850

];

In a straight chart or pivot table add month as dimension and two expressions:

Expression 1 (opening): firstsortedvalue(opening, row)

Expression 2 (closing): firstsortedvalue(closing, -row)

Re: closing opening

lironbaram — Mon, 27 May 2013 12:03:25 GMT

i have a look at the attach file

Re: closing opening

Mon, 27 May 2013 12:04:00 GMT

You could add a monthnumber :

LOAD * INLINE [
     monthnum, month, opening, closing
     1, apr, 100, 200
     2, may, 200, 500
     3, jun, 300, 700
     4, july, 250, 850
];

and then use

=FirstSortedValue(opening,monthnum)

=FirstSortedValue(closing,-monthnum)

Re: closing opening

kumarnatarajan — Mon, 27 May 2013 12:17:14 GMT

hi,

Find the attached file.