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

[#1]

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 ₺')

[sunny_talwar]

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 ₺')

[#3]

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.

[sunny_talwar]

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)

[#5]

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

[sunny_talwar]

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

[Kushal_Chawda · Accepted solution]

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 ₺')

[#8]

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.