topic Re: Value in text object in QlikView

Value in text object

upaliwije — Sat, 23 Nov 2019 11:25:51 GMT

Hi Friends,

I have text object in my qlikview doc, and I want to show a value in it with following expression.

IF(AVERAGE>0,SUM(MIN))

but it returns no value. Pls help me to rectify my expression

Re: Value in text object

Stoyan_Terziev — Sat, 23 Nov 2019 16:56:03 GMT

Hi Upali,

I’ve been looking at your post for couple of hours already and seem you haven’t got your answer yet. Working on a Saturday... must be tough. I am on a phone but I will try to give you some directions. So bear with me...

You must have a table with several measures and dimensions. Let’s imagine you have sales transactions. And there is a measure called [Sales USD].

You need to know the Avg Sales amount per transaction line? Here is your expression:

=Avg([Sales USD])

You need to know the absolute minimum value among all the lines? Here you go:

=Min([Sales USD])

You only need to know the minimum value as long as the average is above 0? Here:

=if(Avg([Sales USD])>0, Min([Sales USD]))

Keep in mind, from practical stand point this expression doesn’t look like something you will find useful in practice.

I hope that help!

Kind regards,

S.T.

Re: Value in text object

Anil_Babu_Samineni — Sun, 24 Nov 2019 13:35:19 GMT

Try this?

SUM({<AVERAGE={'>0'}>} MIN)

Re: Value in text object

Brett_Bleess — Thu, 05 Dec 2019 22:36:43 GMT

Upali, did either Stoyan or Anil's posts get you what you needed? As always, if either of them did, be sure to circle back and use the Accept as Solution button on the post(s) that helped to give them credit for the assistance and to let other Community Members know what worked. If you still need assistance, leave an update with what you need.

Regards,
Brett