topic Re: Expression not showing in QlikView

Expression not showing

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

¿can you help me with the second expression of the attached file?

i want to get on one expression the total clients, and on the second the clients of the month.

thank you

adamdavi3s — Tue, 17 Jan 2017 11:45:10 GMT

Ok so your expression doesn't work because you don't have the date_load in the table, so Qlik doesn't really know what to do the comparison on.

If you will only have one date load then you can use the following:

if(date_client=only(date_load),sum(clients))

However if you will have multiple, then you might be better to do this in your load script, something like this:

LOAD clients, date_client, date_load, if(date_client = date_load,clients) as LoadClients

FROM date.xlsx (ooxml, embedded labels);

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

This will help users identify the answers should they come across this thread in the future.

susovan — Tue, 17 Jan 2017 11:47:17 GMT

Hi,

Try this following expression,

But you have to select any of the 'date_client'

1) sum(TOTAL{<clients=,date_client=,date_load>} clients)

2) if(date_client=date_load,sum(clients))

Anonymous — Tue, 17 Jan 2017 16:33:34 GMT

hello,

the second expression is not working.

i already tried it.

thank you

trdandamudi — Tue, 17 Jan 2017 17:06:50 GMT

Hope this is what you are looking for:

First Expression:

sum(clients)

Second Expression:

Sum({<clients={"=date_client=date_load"}>} clients)

eespiritu — Tue, 17 Jan 2017 17:07:10 GMT

I understand this, you want:

First expression: Total client

Second expression: Client per month

My advice is change the dimension date_load to date_client. In the expression tab:

First expression: sum(TOTAL clients)
Second expression: sum(clients)

Regards,

Enrique.