topic Re: Formula difficulties - compare two values in QlikView

Formula difficulties - compare two values

Thu, 14 Jun 2012 14:33:59 GMT

Hi all,

I have two parameters in my dashboard, that I would like to use as a filter.

So, when the salesdepartment (CI_AFD) that is selected = 'team1', I want to only see products with the value 'team1' (afd_ci)

I thought to fix it by using this as formula:

= sum({$<CI_AFD = {$(afd_ci)} >}OMZET)

but that does not work.

Any ideas?

greetings,

Wouter

Re: Formula difficulties - compare two values

Miguel_Angel_Baeyens — Thu, 14 Jun 2012 14:37:17 GMT

Hi,

Try using single quotes, because the value in variable is a text string:

=Sum({< CI_AFD = {'$(afd_ci)'} >} OMZET)

Hope that helps.

Miguel

Re: Formula difficulties - compare two values

Mon, 18 Jun 2012 10:22:06 GMT

Hi Miguel,

Unfortunately it didn't work. ( I don't see data).

What works is if I use this formula:

=sum({$<CI_AFD = {'CI - CendrisZakelijk'}>}OMZET)

However, instead of hard coding the variabel, I want to use the selection from the field ci_afd

Any other ideas?

Re: Formula difficulties - compare two values

Miguel_Angel_Baeyens — Mon, 18 Jun 2012 10:31:12 GMT

Hi Wouter,

Then you should define your variable in the Settings menu, Variable Overview as

=Chr(39) & Concat(CI_AFD, Chr(39) & Chr(44) & Chr(39)) & Chr(39)

So if you put the variable in a text object you see values single quoted and comma separated, which is a format ready to use in set analysis: 'Value','Value2','Value3'

Using the expression suggested should now work

Hope that helps.

Miguel

Re: Formula difficulties - compare two values

Mon, 18 Jun 2012 10:38:36 GMT

Hi Miguel,

It does change the outcome. However it gives an empty table.

Should I make a new LET or SET variabel?

thanks for the efforts!!

Wouter

Re: Formula difficulties - compare two values

Miguel_Angel_Baeyens — Mon, 18 Jun 2012 10:47:04 GMT

Hi Wouter,

You don't need to use LET or SET because you are creating the variable in run time. Check the application for a dummy example on how this works.

Hope that helps.

Miguel

Re: Formula difficulties - compare two values

Mon, 18 Jun 2012 11:30:34 GMT

The following now works:

=Sum({$< CI_AFD = afd_ci >} OMZET)

Thanks you Miguel, l wouldn't have solved it without your help!!

Wouter