topic Re: how to insert 5days data in table in QlikView

how to insert 5days data in table

Tue, 18 Feb 2014 07:22:15 GMT

Hi,

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

Re: how to insert 5days data in table

Tue, 18 Feb 2014 07:38:49 GMT

hi hima,

can explain your problem in brief for Clear understanding

Re: how to insert 5days data in table

sivarajs — Tue, 18 Feb 2014 07:39:32 GMT

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

Re: how to insert 5days data in table

Tue, 18 Feb 2014 07:46:59 GMT

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.

Re: how to insert 5days data in table

Tue, 18 Feb 2014 07:52:35 GMT

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

Re: Re: how to insert 5days data in table

Tue, 18 Feb 2014 08:22:40 GMT

please find attachment

hope this helps you

Re: how to insert 5days data in table

Tue, 18 Feb 2014 09:42:48 GMT

pls find d attached , to understand d issue.