topic Re: analyse modifier in QlikView

analyse modifier

Mon, 29 Aug 2011 13:16:54 GMT

Hi all,

I'm new and just started to learn the basics of qlikview. but now i want to try to use this:

count ({<Type={'M'}>} Type)

But it seems like it doesn't filter. The result is the same when I use count(type).

What I am trying to achieve:

There is one column called Type. In there are several diffrent types and I want a table with total of all types and per type.

Thanks

Mon, 29 Aug 2011 13:50:48 GMT

Hi,

first suggestion:

create a straight table (chart) with dim = Type and expression = count(Type).

second suggestion:

create a listbox with Type and check on general tab "show frequency".

HtH

Roland

SunilChauhan — Mon, 29 Aug 2011 14:01:23 GMT

see the attched file .its seems working.

if not please share some sample

Thu, 01 Sep 2011 05:57:03 GMT

Thanks for your reply but I can't open the file.