select data of last 4 weeks.

[#1]

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 · Accepted solution]

db = qlikview db?

use a week serial as suggested here

https://community.qlikview.com/message/136895

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

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

[#3]

yes from qlikview db.

[#4]

as i am new please explain briefly.

[Siva_Sankar]

hi  pramod,

Can you attach your qvw application?

[#6]

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]

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

[#8]

hi,

anyone please help for the above question.

Thanks,

Pramod