topic Set Analysis in QlikView

Set Analysis

pkelly — Thu, 23 Jul 2015 10:56:40 GMT

Hi all

Trying to get into Set Analysis more and have converted a few IF statements...

=sum(IF(Date(ind_Date, 'DD/MM/YYYY') = Date(varToday, 'DD/MM/YYYY'), ind_OnHandValue))

How would you go about writing the above in Set Analysis?

Thanks in advance for any assistance.

Regards

Paul

Kushal_Chawda — Thu, 23 Jul 2015 10:59:39 GMT

Try

Sum({<ind_Date ={"$(=varToday)"}>}ind_OnHandValue)

Your ind_Date and variable date format should match

sunny_talwar — Thu, 23 Jul 2015 11:00:08 GMT

Try this:

=Sum({<ind_Date = {"=Date(ind_Date, 'DD/MM/YYYY') = Date(varToday, 'DD/MM/YYYY')"}>} ind_OnHandValue))

swuehl — Thu, 23 Jul 2015 11:00:56 GMT

If ind_Date field is formatted as a number and the variable as well, try:

=Sum( {<ind_Date = {$(varToday)} >} ind_OnHandValue)

Basically field ind_Date and your set modifier should be formatted the same.

If ind_Date is formatted as Date DD/MM/YYYY, try:

=Sum( {<ind_Date = {'$(=Date(varToday,'DD/MM/YYYY))'} >} ind_OnHandValue)