Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you post sample of your data and the way you want to see the results?
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
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-qlik
sense-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>
I can not see any file....
Did you attached it via Advance Editor?
Look at the right hand top corner of this Replay window
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-qlik
sense-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>
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....