topic Re: Text object Changing data when selections made in QlikView

Text object Changing data when selections made

mcoetzee — Mon, 18 Nov 2019 06:37:45 GMT

Hi, I need some help i am trying to make a text object but the value should stay the same, it should ignore my fiscal year and fiscal month when selections are made.

I have tried the below but it does not seem to be working, i have also tried to add a action in but still no luck, whom can help me please?

='All Active Clients: ' & num(Count({1}{<ContractActive = {'Y'}>}DISTINCT CustId))

Re: Text object Changing data when selections made

mahaveerbiraj — Mon, 18 Nov 2019 06:50:49 GMT

Try like below,

='All Active Clients: ' & Count({1<ContractActive = {'Y'}>}DISTINCT CustId)

Re: Text object Changing data when selections made

Victor_Alumanah — Mon, 18 Nov 2019 09:46:37 GMT

replace the fiscal month and year with your names 🙂

='All Active Clients: ' & num(Count({<ContractActive = {'Y'},Fiscal_Year=,Fiscal_Month=>}DISTINCT CustId))

Re: Text object Changing data when selections made

sunny_talwar — Mon, 18 Nov 2019 12:15:33 GMT

I think @mahaveerbiraj 's solution should work if you need to ignore all selections... but the reason your expression didn't work was because your expression added a new set to ignore all selection instead of adding it to the current set that you already had (Red is one set and Green is another set and I think when you write it like this, it does an intersection of the two set, but don't quote me on this)

='All Active Clients: ' & num(Count({1}{<ContractActive = {'Y'}>}DISTINCT CustId))

But, if you really just need to ignore selection in two fields... you might just need what @Victor_Alumanah has provided, but with your own field names

='All Active Clients: ' & Num(Count({1}{<ContractActive = {'Y'}, MasterCal_FiscalYear, MasterCal_FiscalMonth>} DISTINCT CustId))

Re: Text object Changing data when selections made

mcoetzee — Mon, 18 Nov 2019 12:18:04 GMT

Thank you, its working.

Re: Text object Changing data when selections made

sunny_talwar — Mon, 18 Nov 2019 12:22:07 GMT

Awesome, please mark @mahaveerbiraj and/or @Victor_Alumanah responses as the solution so that future users can benefit from it.

Best,
Sunny

Re: Text object Changing data when selections made

Brett_Bleess — Wed, 20 Nov 2019 15:36:56 GMT

Maarten, please be sure to come back to the thread and use the Accept as Solution button on the post(s) that helped you get things working properly. I would have marked things, but I was not sure which one(s) worked, so we need you to do this as per Sunny's post, and this does two things, it gives credit to the posters, and it confirms to other Community Members visiting this thread what actually worked, so it is important you take the time to do this...

Regards,
Brett