Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Display data difference between 2 months

Hi,

Problem with display the different data rows between 2 months

Description: I would like to create a table where I can show the change of the data between 2 months where the field Admin = 'yes'

Details:
I want to show only these data rows in the table where the Key field "Key" has changed to the previous month,
in my example, where are changes between 2011-Jan and 2011-Feb in the field "Key".

I have tried nearly every possibilities, set analysis with bookmarks, within script, but all without a solution.

I hope somebody could give me a solution for my problem?

Please use the attached .qvw file

Kind regards,

Herbert

1 Solution

Accepted Solutions
pover
Honored Contributor

Display data difference between 2 months

Hi Herbert,

I think this is what you are looking for. Tell me if you have any questions.

Regards.

3 Replies
pover
Honored Contributor

Display data difference between 2 months

Hi Herbert,

I think this is what you are looking for. Tell me if you have any questions.

Regards.

Not applicable

Display data difference between 2 months

Hello Karl,

I have looked at your solution, thank you very much, that is the solution what I need, and it can be used for the comparision in every month.

I have also tried it with set analysis before, but I failed, this is not my strength:-)

Thank you Karl.

Kind Regards,

Herbert

Not applicable

Re: Display data difference between 2 months

Hi,

Karl Power , I have the ID's for example cd001 to cd007 . I want to give the From ID and To ID as parameters and display the rows from ID and To Id. how is it possbile, can you give me some idea.

Regards,

Ramesh

Community Browser