Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Kpi - Comparing two years

Can anyone tell me or post the function KPI values for comparison between two different years? I'm using an XLS file and I'd like to know which fields should contain

Thank a lot

Steve

Tags (1)
6 Replies

Re: Kpi - Comparing two years

Could you post sample of your data and the way you want to see the results?

MVP
MVP

Re: Kpi - Comparing two years

Hi

This will be much easier if you build a proper calendar from the date field - at least year, month, day as well as a full date. If you want a rolling comparison, then you should also have a month sequence number field in the calendar

HTH

Jonathan

Not applicable

Re: Kpi - Comparing two years

Thank for your help. Attached XLS example.

Regards, Steve

Il giorno 24/feb/2015, alle ore 11:58, Robert Mika <qcwebmaster@qlikview.com> ha scritto:

Kpi - Comparing two years

reply from Robert Mika <http://community.qlik.com/people/Robert_Mika?et=watches.email.thread> in New to Qlik Sense - View the full discussion <http://community.qlik.com/message/720010?et=watches.email.thread#720010>

Could you post sample of your data and the way you want to see the results?

Reply to this message by replying to this email, or go to the message on Qlik Community <http://community.qlik.com/message/720010?et=watches.email.thread#720010>

Start a new discussion in New to Qlik Sense by email <mailto:discussions-community-qliksense-newtoqliksense@qliktech-public.hosted.jivesoftware.com> or at Qlik Community <http://community.qlik.com/choose-container.jspa?contentType=1&containerType=14&container=2146&et=watches.email.thread>

© 1993-2014 QlikTech International AB | Copyright & Trademarks <http://www.qlikview.com/us/info/copyright> | Privacy <http://www.qlikview.com/us/info/privacy> | Terms of Use <http://www.qlikview.com/us/info/terms-of-use> | Software EULA <http://www.qlikview.com/us/info/software-eula>

Re: Kpi - Comparing two years

I can not see any file....

Did you attached it via Advance Editor?

Look at the right hand  top corner  of this Replay window

Not applicable

Re: Kpi - Comparing two years

Retry.

I need to visualize value of quantity, filter by Family and select year of interest.

Thank

Steve

Il giorno 24/feb/2015, alle ore 12:23, Robert Mika <qcwebmaster@qlikview.com> ha scritto:

Kpi - Comparing two years

reply from Robert Mika <http://community.qlik.com/people/Robert_Mika?et=watches.email.thread> in New to Qlik Sense - View the full discussion <http://community.qlik.com/message/720093?et=watches.email.thread#720093>

I can not see any file....

Did you attached it via Advance Editor?

Look at the right hand top corner of this Replay window

Reply to this message by replying to this email, or go to the message on Qlik Community <http://community.qlik.com/message/720093?et=watches.email.thread#720093>

Start a new discussion in New to Qlik Sense by email <mailto:discussions-community-qliksense-newtoqliksense@qliktech-public.hosted.jivesoftware.com> or at Qlik Community <http://community.qlik.com/choose-container.jspa?contentType=1&containerType=14&container=2146&et=watches.email.thread>

© 1993-2014 QlikTech International AB | Copyright & Trademarks <http://www.qlikview.com/us/info/copyright> | Privacy <http://www.qlikview.com/us/info/privacy> | Terms of Use <http://www.qlikview.com/us/info/terms-of-use> | Software EULA <http://www.qlikview.com/us/info/software-eula>

Re: Kpi - Comparing two years

Not sure what you see but I see this 'garbage'

Il giorno 24/feb/2015, alle ore 12:23, Robert Mika <qcwebmaster@qlikview.com> ha scritto:

Kpi - Comparing two years

reply from Robert Mika <http://community.qlik.com/people/Robert_Mika?et=watches.email.thread> in New to Qlik Sense - View the full discussion <http://community.qlik.com/message/720093?et=watches.email.thread#720093>

I can not see any file....