topic Re: select data of last 4 weeks. in QlikView

select data of last 4 weeks.

Sat, 02 May 2015 10:59:41 GMT

Hi,

I need to select the data of last 4 weeks from the db.

Please help me to do. i have attached the snapshot how it has to be appear.

Thanks,

Pramod

maxgro — Sat, 02 May 2015 11:16:06 GMT

db = qlikview db?

use a week serial as suggested here

in chart with set analysis (adapt to your fields and data)

sum($ <weekserial={"<=$(=(max(weekserial)))>=$(=(max(weekserial)-4))"}> something)

Sat, 02 May 2015 11:30:40 GMT

yes from qlikview db.

Sat, 02 May 2015 11:33:22 GMT

as i am new please explain briefly.

Siva_Sankar — Sat, 02 May 2015 12:04:47 GMT

hi pramod,

Can you attach your qvw application?

Sat, 02 May 2015 12:10:36 GMT

hi siva sankar,

i don't even know how to attach it.

sorry this is qliksense not qlikview.

actually i have loaded the data and i have measures too, but i need a expression for dimension to load the data of only last 4 weeks.

Thanks,

Pramod

Anonymous — Sat, 02 May 2015 13:02:03 GMT

It is .qvf file, most likely in C:\Users\<you>l\Documents\Qlik\Sense\Apps

Mon, 04 May 2015 13:08:16 GMT

hi,

anyone please help for the above question.

Thanks,

Pramod