topic Re: How to include all months in Text Object by using Expression? in QlikView

How to include all months in Text Object by using Expression?

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone,

I've been searching in the community for an answer but didn't get any answers for it. As a firm, we started to use Qlikview and since our database access is limited I've been trying to see where I am at with my sales summary.

I am using a Text Object. Here is what I have in it.

I want to include all the months for AY and show my SUM on SATIRNETTUTARI and going to use percentage later to see where I am at. like im on %50 or 60 etc... I hope I made myself clear.

= '2016 Hedefim:' & ' ' & '6.860.000 ₺' & '

' & AY & ' ' & 'durum:' & ' ' & money(Sum(SATIRNETTUTARI),'#.##0,00 ₺;-#.##0,00 ₺')

Re: How to include all months in Text Object by using Expression?

sunny_talwar — Mon, 30 May 2016 11:15:12 GMT

You mean to say that you are making selection in MonthField and yet want this text box to show for all Months? Try this:

= '2016 Hedefim:' & ' ' & '6.860.000 ₺' & '

' & AY & ' ' & 'durum:' & ' ' & money(Sum({<Month = >}SATIRNETTUTARI),'#.##0,00 ₺;-#.##0,00 ₺')

Re: How to include all months in Text Object by using Expression?

Mon, 30 May 2016 11:26:08 GMT

i.e. In my List Box, I selected "MAY" as Month to filter my sales from MAY 2016, but in the Text Object, I want to show all 12 months to see where I am at with my sales target.

Re: How to include all months in Text Object by using Expression?

sunny_talwar — Mon, 30 May 2016 11:36:02 GMT

The above expression should work then.

= '2016 Hedefim:' & ' ' & '6.860.000 ₺' & '

' & AY & ' ' & 'durum:' & ' ' & money(Sum({<Month = >}SATIRNETTUTARI),'#.##0,00 ₺;-#.##0,00 ₺')

Just replace Month (in red) with the exact name of the month field where you are making selection (MAY)

Re: How to include all months in Text Object by using Expression?

Mon, 30 May 2016 12:21:28 GMT

All right, this worked except it shows all the sales department's sales.

We have a field for Sales Representative called "SATISTEMSILCISI". How can I add this field into the Text Object so that it can only show mine

Re: How to include all months in Text Object by using Expression?

sunny_talwar — Mon, 30 May 2016 16:46:44 GMT

Not sure I follow this part. Can you share some more information about this part?

Re: How to include all months in Text Object by using Expression?

Kushal_Chawda — Mon, 30 May 2016 16:56:09 GMT

You just create the list box for sales representative, select the representative you want and change the expression

= '2016 Hedefim:' & ' ' & '6.860.000 ₺' & '

' & AY & ' ' & 'durum:' & ' ' & SATISTEMSILCISI &':'& money(Sum({<Month = >}SATIRNETTUTARI),'#.##0,00 ₺;-#.##0,00 ₺')

Re: How to include all months in Text Object by using Expression?

Tue, 31 May 2016 06:07:11 GMT

I already have a list box for Year, Month, Sales Representative, Product and Company.

This is kind of something that I wanted but I can work with this. Thank you.