QlikView App Dev

Report Inappropriate Content · ‎2014-07-11

Hi,

This is Varun.

I Have a requirement(YTD), where I need to display present year data and previous year data.Below is my sample data as well as required data.

Sample Data:

Customer_id Year Amount

1 2007 100

2 2007 200

1 2006 300

3 2006 400

If I select Customer_id, then it should show the corresponding data.

Required Data:

Customer_id Present_Year Previous_Year Amount

1 2007 2006 400

2 2007 - 200

3 - 2006 300

Can anyone please help me.

Thanks & Regards,

Varun Reddy Kancharla

MK_QSL · ‎2014-07-12

Hi Varun,

It's possible...

Create a Straight Table

Dimension

Customer_id

Expressions

1) IF(Max(TOTAL<Customer_id>Year)=Max(TOTAL Year),Max(TOTAL Year))

2) IF(Min(TOTAL <Customer_id> Year) = Min(TOTAL Year), Min(TOTAL Year))

3) SUM(Amount)

IamBack · ‎2014-07-12

Can you please be more clear

as i see for custid 1 2007 you want max of 2006

but cust ID 2 2007 amount is of what year is a question

Sunil Chauhan

Report Inappropriate Content · ‎2014-07-12

This is the work I have done. I am getting same data for YTD and Previous YTD.My requirement is to get data between ( presentyear and start(presentyear) ) and (previousyear and start(peviousyear) .

My variables:1. vpyear=(addmonths(date(now()),-((year(now() )-Year)*12)))2. vstartyear=YearStart(vpresentyear)3. vprevyear=(addmonths((vpresentyear),-12))4. vprevstartyear=YearStart(vpreviousyear) My code for Present Year-to_date is:= count({}PO_LINE_LOCATIONS_ALL.QUANTITY)

Date: Sat, 12 Jul 2014 03:31:07 -0400

From: qcwebmaster@qlikview.com

To: varunreddykancharla@outlook.com

Subject: Re: - Can any one please help me out with this issue(T2D)

Qlik Community

Can any one please help me out with this issue(T2D)

reply from Manish Kachhia in New to QlikView - View the full discussion

Hi Varun,

It's possible...

Create a Straight Table

Dimension

Customer_id

Expressions

1) IF(Max(TOTAL Year) = Min(TOTAL Year), Min(TOTAL Year))

3) SUM(Amount)

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community

Following Can any one please help me out with this issue(T2D) in these streams:

Inbox

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

MK_QSL · ‎2014-07-12

I am confused now.... In this post you haven't mentioned any variable and I tried to match as per your requested result. Now you are talking about something completely different.

Better if you provide sample data with your exact requirements to avoid any duplication of work at helper end also.

Hope you can be more specific in your exact requirements by providing sample data and result in excel file..

Would love to help you out...

Thanks and Regards

Manish Kachhia

Report Inappropriate Content · ‎2014-07-12

This is the work I have done. I am getting same data for YTD and Previous YTD.My requirement is to get data between ( presentyear and start(presentyear) ) and (previousyear and start(peviousyear) .My variables:1. vpyear=(addmonths(date(now()),-((year(now() )-Year)*12)))2. vstartyear=YearStart(vpresentyear)3. vprevyear=(addmonths((vpresentyear),-12))4. vprevstartyear=YearStart(vpreviousyear) My code for Present Year-to_date is:= count({}PO_LINE_LOCATIONS_ALL.QUANTITY)

Can you please help me out. If there are any doubts regarding question, please ping me.

Date: Sat, 12 Jul 2014 05:04:07 -0400

From: qcwebmaster@qlikview.com

To: varunreddykancharla@outlook.com

Subject: Re: - Can any one please help me out with this issue(T2D)

Qlik Community

Can any one please help me out with this issue(T2D)

reply from chauhans85 in New to QlikView - View the full discussion

Can you please be more clear

as i see for custid 1 2007 you want max of 2006

but cust ID 2 2007 amount is of what year is a question

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community

Following Can any one please help me out with this issue(T2D) in these streams:

Inbox

Copyright & Trademarks | Privacy | Terms of Use | Software EULA

Report Inappropriate Content · ‎2014-07-12

Second requirement is what I wanted. By using straight chart I should obtain sum(amount) between Present Year-to-Date i.e,(1/1/2014-7/12/2014) and also Previous Year-to-Date i.e,(1/1/2013-7/12/2013).

For this requirement, I have created variables and tried to write expression using set analysis.Below are the set analysis, which I have written for both Present Year-To-Date and Previous Year-To-Date.

My code for Present Year-to_date is:= count({}PO_LINE_LOCATIONS_ALL.QUANTITY)

Below mentioned are my variables.1. vpyear=(addmonths(date(now()),-((year(now() )-Year)*12)))2. vstartyear=YearStart(vpresentyear)3. vprevyear=(addmonths((vpresentyear),-12))4. vprevstartyear=YearStart(vpreviousyear)

Hope I am clear this time.

Date: Sat, 12 Jul 2014 10:14:06 -0400

From: qcwebmaster@qlikview.com

To: varunreddykancharla@outlook.com

Subject: Re: - Can any one please help me out with this issue(T2D)

Qlik Community

Can any one please help me out with this issue(T2D)

reply from Manish Kachhia in New to QlikView - View the full discussion

I am confused now.... In this post you haven't mentioned any variable and I tried to match as per your requested result. Now you are talking about something completely different.

Better if you provide sample data with your exact requirements to avoid any duplication of work at helper end also.

Hope you can be more specific in your exact requirements by providing sample data and result in excel file..

Would love to help you out...

Thanks and Regards

Manish Kachhia

Reply to this message by replying to this email, or go to the message on Qlik Community

Start a new discussion in New to QlikView by email or at Qlik Community

Following Can any one please help me out with this issue(T2D) in these streams:

Inbox

Copyright & Trademarks | Privacy | Terms of Use | Software EULA