topic Re: Problems with application from data source in Excel - in particular "GetCurrentField ... etc etc" in QlikView

Problems with application from data source in Excel - in particular "GetCurrentField ... etc etc"

Fri, 22 May 2015 12:43:56 GMT

Goodmorning everyone,

I am creating an application that analyzes the visits to clients from my sales force.

The analysis I set three types of partners:

Customers;

Potential customers;

Suppliers.

Sheet "General"

I created a group for the pie chart given by 3 types Customers, Potential Customers and Suppliers in Tab size

and in Table Expressions I entered the following formula:

if (GetCurrentField ([New Group]) = 'customer',

count ([Customer]),

count ([potential customer]))

and it seems to work, I added a line like below

if (GetCurrentField ([New Group]) = 'customer',

count ([Customer]),

count ([potential customer])),

count ([Manufacturer])

and does not represent me any more pie ... why?

Second request .... always in sheet general under the graph in the grid right you can select customers and potential customers, and it seems to work .... even if I add here suppliers do not work anymore.

This first grid separates me the details by type of partner and that's fine but I also want a comprehensive view on the grid right ... someone help me know?

Thank you all in advance.

Re: Problems with application from data source in Excel - in particular "GetCurrentField ... etc etc"

swuehl — Fri, 22 May 2015 12:46:42 GMT

An if() function only takes up to three arguments, conditon, then-branch, else-branch. That's why your modification doesn't work. Use a pick/ match combination instead.

Re: Problems with application from data source in Excel - in particular "GetCurrentField ... etc etc"

Fri, 22 May 2015 12:54:20 GMT

Hi,

How can I do? you can please make me an example in my file attachment?

Thanks.

Re: Problems with application from data source in Excel - in particular "GetCurrentField ... etc etc"

swuehl — Fri, 22 May 2015 13:03:57 GMT

pick(match(GetCurrentField([Nuovo Gruppo]),'Cliente', 'Cliente Potenziale','Fornitore'),

count([Cliente]),

count([Cliente Potenziale]),

count([Fornitore])

)