topic Display data difference between 2 months in QlikView

Display data difference between 2 months

Thu, 17 Feb 2011 18:36:25 GMT

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

Display data difference between 2 months

pover — Thu, 17 Feb 2011 19:46:29 GMT

Hi Herbert,

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

Regards.

Display data difference between 2 months

Fri, 18 Feb 2011 09:32:31 GMT

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

Re: Display data difference between 2 months

Fri, 08 Mar 2013 12:36:45 GMT

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