topic Re: convert straight table into pivot table expression fails in QlikView

convert straight table into pivot table expression fails

cafcptg2011 — Tue, 10 Feb 2015 20:16:04 GMT

Hi,

I have straight table and i need to convert into a pivot table. (i need to know the stores/client that has sales only in a Stores Date)...

my table (and is correct):

when i convert to pivot table (pivot table doesn't show nothing ?!). my expression fails. why??

my Dimensions:

Store and Client

my current expression is :

if(SalesDate = StoreDate, count(Distinct Client))

Can anyone help me please?

thanks in advance,

CAFC

rwunderlich — Tue, 10 Feb 2015 23:21:26 GMT

You have the if() and count() reversed. Your expression should be:

=count(Distinct if(SalesDate = StoreDate, Client))

-Rob

avinashelite — Wed, 11 Feb 2015 14:55:17 GMT

Nothing wrong with the expression, in the presentation tab check the always fully expanded it will work

cafcptg2011 — Wed, 11 Feb 2015 15:26:47 GMT

thanks is correct!

thanks very much

rwunderlich — Wed, 11 Feb 2015 18:31:34 GMT

A "correct" chart expression -- that is, using aggregation -- should work expanded or not. See

-Rob