Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Peek function to get change in col value

hi,

i am looking for script which give how many time P_ID is change from green to red in a month..

My source table look like

Date                P_ID               Status

1 jan 2012          1                    Green

2 jan 2012          1                    Green

3 jan 2012          1                    RED

4 jan 2012          1                    Green

5 jan 2012          1                    Green

6 jan 2012          1                    RED

7 jan 2012          1                    RED

8 jan 2012          1                    RED

.........

1 Feb 2012          2                    Green

2 Feb 2012          2                    Green

3 Feb 2012          2                    RED

4 Feb 2012          2                    RED

5 Feb 2012          2                    Green

6 Feb 2012          2                    Green

........

and output which i need look lke

Month          P_ID          count of Change to Red

Jan 2012         1               2

Feb 2012         2              1

thanks

Community Browser