Pivot Table

[bharatkishore]

Dear All,

I  am using a pivot chart and have taken 3 dimensions i.e. name(needed only 3 names out of 10 names so hard coded in dimension), task(needed only 4 fields out of 10 fields so hard coded in dimension), priority(needed only 4 fields out of 6 fields so hard coded in dimension)..I have given an expression like count(task_No)...

In the attached image i.e. (values) u can see pending tickets column where can see 3 values for names..So that data is for today and tomorrow again it got reloaded means the values will be changing... Now my requirement if tomorrow the data got reloaded means the pending tickets values will be changing..So i want to see yesterday values and today values like that for a period of minimum 5 days..

Can you please tell me how can we acheive this..

Regards,

Bharat

[Siva_Sankar]

Bharat,

To have current day, previous n days calculation use set analysis. Not sure about your script and data. Refer examples here to get idea https://community.qlik.com/thread/89914

[bharatkishore]

HI Siva,

Thanks for the reply..My issue is it is not about current day and previous day selections..I need to store the value for the pending tickets(that last column value i have given the partial sums of the second dimension)..Now again tomorrow those values will be changing..Now i need to show both yesterday values as well as today value like that for a period of 5 days..Is it possible to achieve this.