topic Re: Set analysis in straight table, how to display out previous record/value? in QlikView

Set analysis in straight table, how to display out previous record/value?

jim_chan — Fri, 28 Oct 2016 05:48:37 GMT

Hi guys,

I am creating a straight table to display previous and current value. i am plannign to write in the fron end. but how to write in set analysis? any example?

For exmaple: I want to display out a ranking of an item - current is Rank1, previous is rank 5. So, i need to create an expression to display the previous value.

Rgds,

Jim

Re: Set analysis in straight table, how to display out previous record/value?

robert_mika — Fri, 28 Oct 2016 06:02:57 GMT

What do you mean by previous?

Has the value change since the data been re-loaded?

or the values have some condition that make the rank so they already exist in the current dataset.

Feeling Qlikngry?

How To /Missing Manual(25 articles)

QlikSteps - Blog

Re: Set analysis in straight table, how to display out previous record/value?

jim_chan — Fri, 28 Oct 2016 06:05:34 GMT

Yes. it been reloaded. For instance.

Year 2015 data - record ID 123456. is rank 7

Year 2016 data - record ID 123456, ir rank 8

So, i want to create a straight table to display the record id , and its current rank(rank8) and previous rank(rank7).

Re: Set analysis in straight table, how to display out previous record/value?

vardhancse — Fri, 28 Oct 2016 06:42:33 GMT

Create variables for previous values and use in set anaylysis expression

Re: Set analysis in straight table, how to display out previous record/value?

dimitar_angelov — Fri, 28 Oct 2016 07:24:40 GMT

Hi Jim,

I am newbie but here is what I did for you:

max({<Year={$(vThisYear)}>}Rank)

max({<Year={$(vPreviousYear)}>}Rank)

Note: use min() or max() depending on your ranking system (if its ascending or descending)

vThisYear=max(Year)

vPreviousYear=max(Year-1)

You will get a table like this:

Hope this helps.

Regards,

Dimitar