topic Re: adding field issue in QlikView

adding field issue

soniasweety — Sat, 16 Nov 2024 03:38:33 GMT

Hi all,

i m facing one issue . i have used alternate states in my charts . below using expression.

=sum({<Source=$::Source,Region=$::Region,Country=$::Country,Quarter=$::Quarter,Month=$::Month,[Business Area Code]=$::[Business Area Code],Lifecycle=$::Lifecycle>}[Net Sales])

only lifecyle field is not working. i mean chart is not showing data for that perticlar field included.

as lifecycle field doesnt have data ( if we put any data into that field chart is showing).

so my question is if any data is not there in field y the chart not showing . any alternate is there for this?

Re: adding field issue

sunny_talwar — Wed, 08 May 2019 12:03:03 GMT

There is no data in lifestyle field? You mean dashboard wide there is no data in the field? I have seen set analysis to behave in a weird manner when you use set analysis on a field which have all null values. I am not sure if that is what you are running into here.

Re: adding field issue

soniasweety — Wed, 08 May 2019 12:04:26 GMT

Not dashboard wise. there is a field type for hardware type there is no data. for service type data is there

Re: adding field issue

sunny_talwar — Wed, 08 May 2019 12:06:49 GMT

Oh that is strange, would you be able to share a sample where we can see the issue?

Re: adding field issue

soniasweety — Wed, 08 May 2019 12:09:04 GMT

i will add in some time. its big app 😞