how to insert 5days data in table

[#1]

Hi,

I am new to qlikview, can any1 pls tel me hw do i insert 5 days data in pivot table?

[#2]

hi hima,

can explain your problem in brief for Clear understanding

[sivarajs]

If you want to have only 5 days data then do sum(if(date=today() and date <=today()-4,value)) in pivot experssion

[#4]

Hi,

I have to create a table called pending calls fr 5 days . in whch i ve to count of pending calls for pervious 5 days. I am unable to do that.

[#5]

If you mean by dimension, there are a few ways. One is to use an artificial dimension.

Dimension

Valueloop(today()-4,today(),1)

Expression

Pick(match(Valueloop(today()-4,today(),1)......) {an example of how to read the valueloop}

The other is to say if(DateField>Value1 and DateField<=Value2,DateField). Tick the supress nulls tick box and you have your 5 days with an expression of count() or sum() as an example

[#6]

hi

please find attachment

hope this helps you

[#7]

Hi

pls find d attached , to understand d issue.