Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

himadrilaha_201
New Contributor

Need to show result in latest month in pivot table

Hi,

We have the following requirement:


ID

OutcomeDate
1234abcd20th Oct 2017   
1234bcde20th Sep 2017

We need to show the days difference between two Outcomes,when the ID is same.

and will be showing in a pivot table,which shows the month wise values.

In pivot table we need to show in Oct 2017 , and the result will be 30 for this above example, how we can achieve this scenario ?

Thanks in Advance...

5 Replies

Re: Need to show result in latest month in pivot table

Is Outcome one of your dimension? or will you only have ID as dimension.

If Outcome is a dimension... may you just need this

Date - Below(Date)

himadrilaha_201
New Contributor

Re: Need to show result in latest month in pivot table

No, Outcome is not our dimension.

There are 2 dimensions, 1 st one is bucket. Bucket logic is days difference when outcome= abcd and outcome= bcde. fetching the days difference from Date field.

and another is the time dimension,this dimension we  are fetching from the Date field. where we will be showing Month Year( eg. Oct 2017).

and we need to show the days difference for this bucket in Max month year dimension.

Re: Need to show result in latest month in pivot table

How would the output table look like for the two rows of data you have provided above?

himadrilaha_201
New Contributor

Re: Need to show result in latest month in pivot table

Its a Pivot table. In row , we will be having the bucket(X), and in column we will be having the Month year Dimension.

The table will look like the below structure:

   

png.PNG

pablolabbe
Valued Contributor II

Re: Need to show result in latest month in pivot table

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

Community Browser