NEED URGENT SOLUTION : show last 6 months data from currently selected month in a chart

[piyush_s11]

Hi,

I want to show last 6 months data from the currently selected month in a chart.

Unfortunately file size is high because of which I am not able to attache the qlik file.

Please find attached screenshot for the same.

Please let me know any other detail required

Require your help to solve.

Hi All,

I have attached a sample qlik application.

Request your kind help on this.

Also please note that, if I select a month Feb for year 2018 & then it should show me the data from Sept 2017 to Feb 2018.

Thanks.

[piyush_s11]

Hi Tresesco,

I have attached sample 2 qlik file in which which I have followed your procedure.

Require your help to solve this problem.

Thanks,

Piyush

[tresesco]

Create a date field in the main table using Year and Month field as shown above, then you would be able to use the expression like above.

[piyush_s11]

Hi Tresesco,

Thanks for your reply. Sorry, I am not able to understand what you are trying to say. I have attached qlik file (Sample 2) in which I have added a date field using Month & Year in the script. I would be happy if you make changes in the attached file as per your understanding which will solve my problem.

Thanks,

Piyush

[tresesco]

You have something like:

DATA_VW:

//SQL EXEC [dbo].[sp_MOS_Monthlly_Data_qv] NULL,0,'E-SYSTEMS','-ALL-','-ALL-','-ALL-','-ALL-','380,381,246,247,266,260,165,440,459,486';

SQL

SELECT top 1000 V.*,

CASE

WHEN [FieldID] = 421 THEN 1

.....

Try like (preceding load):

DATA_VW:

Load

     *,

     MakeDate(Year,Month) as Date

;

SQL

SELECT top 1000 V.*,

CASE

WHEN [FieldID] = 421 THEN 1

...

[piyush_s11]

Hi Tresesco,

Thanks for your reply. In the attached qlik file (sample 2) I have already added the same as Temp table. Still it is not working. Need solution for this.

Thanks,

Piyush

[tresesco]

You need to create the date field in DATA_VW table and not as a disconnected table.

[piyush_s11]

Hi Tresesco,

Tried with your solution of preceding load still not getting the result.

Thanks,

Piyush

[piyush_s11]

Hi Treesesco,

Have you found any solution for my issue ?

Thanks,

Piyush

[piyush_s11]

Hi Yogendra,

Any solution for my issue ?

Thanks,

Piyush

[piyush_s11]

Hi Dilip,

Any solution for my issue ?

Thanks,

Piyush