topic Re: Script logic in QlikView

Script logic

Fri, 09 Jan 2015 11:45:18 GMT

Hi all,

I got two months records as listed below

Table Jan:

cno category amount

1 gm1 234

2 gm2 535

3 gm3 789

4 gm4 456

Table feb:

cno category amount

1 gm1 234

2 gm3 535

3 gm3 789

4 gm4 456

how can I show change in category like This Month Category and Previous Month Category in a report. Change occurred in Record no 2

Thanks

Re: Script logic

Anonymous — Fri, 09 Jan 2015 12:23:48 GMT

Hi Janaki,

You can load your tables with diff column names then compare .

find attached qvw.

Let me know if this not your required result.

Re: Script logic

Gysbert_Wassenaar — Fri, 09 Jan 2015 12:28:29 GMT

See attached qvw.

Re: Script logic

Fri, 09 Jan 2015 12:33:24 GMT

Hi Chandel,

In my data model monthly tables are concatenated, I can not change field name . Have you got any other logic to implement, answer will be much appreciated.

Thanks,

Re: Script logic

Anonymous — Fri, 09 Jan 2015 12:41:09 GMT

Please see this

Re: Script logic

Fri, 09 Jan 2015 13:24:28 GMT

Hi Gysbert,

Your logic is working but , i have to show data like

Current month category , Previous month Category

I am having difficulty here, can you help me on this.

Re: Script logic

Anonymous — Fri, 09 Jan 2015 13:32:51 GMT

Hi,

Create flags for category in load statements.

'JAN' as CategoryMonth

'FEB' as CategoryMonth

use this flags in expressions

Re: Script logic

MarcoWedel — Sun, 11 Jan 2015 00:55:32 GMT

is cno an unique ID/key field?

Re: Script logic

jagan — Sun, 11 Jan 2015 02:05:02 GMT

Hi,

Try like this

Data:

LOAD

1 AS Month

FROM JanData;

Concatenate(Data)

LOAD

2 AS Month

FROM FebData;

Now you can use expresions

For Current Month

=Sum({<Month={$(=Max(Month))}>} amount)

For Previous Month

=Sum({<Month={$(=Max(Month) -1)}>} amount)

Hope this helps you.

Regards,

Jagan.

Re: Script logic

Mon, 12 Jan 2015 05:12:06 GMT

No there are some duplicate numbers on that field.