Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

select data of last 4 weeks.

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.

Untitled.png

Thanks,

Pramod

1 Solution

Accepted Solutions
MVP
MVP

Re: select data of last 4 weeks.

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)

7 Replies
MVP
MVP

Re: select data of last 4 weeks.

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)

Not applicable

Re: select data of last 4 weeks.

yes from qlikview db.

Not applicable

Re: select data of last 4 weeks.

as i am new please explain briefly.

Siva_Sankar
Honored Contributor

Re: select data of last 4 weeks.

hi  pramod,

Can you attach your qvw application?

Not applicable

Re: select data of last 4 weeks.

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

mov
Esteemed Contributor III

Re: select data of last 4 weeks.

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

Not applicable

Re: select data of last 4 weeks.

hi,

anyone please help for the above question.

Thanks,

Pramod

Community Browser