topic Re: How to add a Field Value in QlikView

How to add a Field Value

Anonymous — Tue, 03 May 2016 19:33:25 GMT

I have a field 'SIZE' Currently It has values: Grande, Tall and Medium. Sometimes Small also gets added in the records for the same field. Req is to create a straight table that shows count of records by size. My question is how do I show count for SIZE Small is equal

to zero when there are no records with 'Small' field value. Please help.

Re: How to add a Field Value

sunny_talwar — Tue, 03 May 2016 19:36:34 GMT

May be add a Inline Table Like this:

LOAD * Inline [

SIZE

Grande

Tall

Medium

Small

];

And then may be SIZE as dimension and Count({<UniqueIndetifier = {'*'}>}SIZE) and on the presentation tab may be uncheck 'Suppress When Zero'

Re: How to add a Field Value

sunny_talwar — Tue, 03 May 2016 19:38:03 GMT

Note: UniqueIndentifier needs to be a field which isn't null for the table where you have SIZE in. You would want to make sure to not use a field which can have null because then those nulls rows will be excluded.

Re: How to add a Field Value

Anonymous — Tue, 03 May 2016 21:35:07 GMT

Hi Sunny Thank you for your reply. I will post update soon