Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
ilanbaruch
Contributor III

set analysis expression based on field value

hi all,

i have a week day table with values which i want to calculate against WeekDay(now())

any ideas or another way to figure it?

advanced thanks.

week dayvalue
Monday50
Tuesday150
Wednesday 200
Thursday 130
Friday 400
Saturday 330
1 Reply
sinanozdemir
Valued Contributor III

Re: set analysis expression based on field value

Hi,

You can employ Date() function and here is an example by using your data:

Capture.PNG

Hope this helps.