topic Re: How do I do an If? in QlikView

How do I do an If?

Wed, 23 Dec 2015 20:33:04 GMT

Hi all!

I trying to do an If like this:

=If(ALMACEN2='TOMÉ',SUM(VENTA)/COUNT(DISTINCT [FECHA FACTURA])/1000,)

But it doesn't work, what I want to do is to graph only the [Punto de Venta] called "TOMÉ"

Can anybody help me with this please!

Thanks in advance...

Re: How do I do an If?

sunny_talwar — Wed, 23 Dec 2015 21:05:53 GMT

See if this works:

=SUM({<ALMACEN2 = {'TOMÉ'}>}VENTA)/COUNT(DISTINCT {<ALMACEN2 = {'TOMÉ'}>} [FECHA FACTURA])/1000

Re: How do I do an If?

Thu, 24 Dec 2015 14:20:35 GMT

Thank you very much Sunny T, it work perfectly... So I made a little change but the script also work:

=SUM({<ALMACEN2 = {'TOMÉ'}>}VENTA)/COUNT(DISTINCT [FECHA FACTURA])/1000

I think this is the if " ({<ALMACEN2 = {'TOMÉ'}>}"... So is not necessary write it twice...

Thanks again it was very useful to me...

Re: How do I do an If?

sunny_talwar — Thu, 24 Dec 2015 16:51:46 GMT

Great, I am glad you were able to figure it out... Please close the thread since you have got what you were looking for.

Best,

Sunny

Re: How do I do an If?

Thu, 24 Dec 2015 17:14:47 GMT

Sorry I don't know how can I close this discussion... Could you tell me?... I'm new here...

Re: How do I do an If?

Anonymous — Thu, 24 Dec 2015 17:35:20 GMT

Thanks for asking Fernando,

On the left side of each response you can mark either a helpful or correct answer. When you mark an answer correct it closes the thread and also grants points to the person who helped solve your query.

Best Regards and Welcome to Qlik Community!!

Sara