Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

6 Replies
robert_mika
Master III
Master III

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

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

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>

robert_mika
Master III
Master III

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
Author

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>

robert_mika
Master III
Master III

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....