convert straight table into pivot table expression fails

[cafcptg2011]

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))

my qvw is here http://community.qlik.com/servlet/JiveServlet/downloadBody/7912-102-1-10700/TesteOnly.qvw

Can anyone help me please?

thanks in advance,

CAFC

[rwunderlich · Accepted solution]

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

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

-Rob

[avinashelite]

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

[cafcptg2011]

thanks is correct!

thanks very much

[rwunderlich]

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

Conditional Aggregations

Use Aggregation Functions!

-Rob