topic Re: How to get one field value by another field value in QlikView

How to get one field value by another field value

Tue, 11 Oct 2016 10:48:05 GMT

I need to filter the num by date with expression.

1. Get num from 2016/01/02 to 2016/01/04.

2. Get num of 2016/01/05

It's looks easy but I don't know to do.

Any help will be thanks.

shawn-qv — Wed, 12 Oct 2016 06:33:23 GMT

You may try (simple):

sum(if(date>=date('2016/01/02') and date<=date('2016/01/04'), num, 0))

or using set analysis (advance):

sum({<date = {">=date('2016/01/02')<=date('2016/01/04')"}>} num)

adamdavi3s — Wed, 12 Oct 2016 06:54:14 GMT

If you want to display the literals rather than a sum then this should work

=only({<date={'2016/01/05'}>}num)

= concat({<date= {">=('2016/01/02')<=('2016/01/04')"}> } num,',')

sunny_talwar — Wed, 12 Oct 2016 09:11:49 GMT

Here are some more options

1) =Sum({<date = {"$(='>=' & Date(MakeDate(2016, 1, 2)) & '<=' & Date(MakeDate(2016, 1, 4)))"}>} num)

2) =Sum({<date = {"$(=Date(MakeDate(2016, 1, 5)))"}>} num)

Fri, 14 Oct 2016 07:45:52 GMT

maybe this