topic Re: Help with an expression? in QlikView

Help with an expression?

rt_new_user — Mon, 18 Mar 2019 23:28:58 GMT

Hello Users

I am struggling with an expression and hence need a little help.

My requirement is to show on the graph the sum of unique roamers in a country only from the previous day. Each country has a few carriers, so the expression should add Unique roamers for each carrier and show it as a total for that country (but only for yesterday date).

My graph 'Roamer count from yesterday' however is showing pretty much double the amount. I am using the below expression:

Sum ( {<Date = {"$(=Date(Max(Date), 'DD/MM/YY'))"}>} Unique_Roamers)

Taking example of China in the picture below we should see '6276' unique roamers ( 2075+4201), but in the graph it is showing '12552' unique roamers.

The expression should only sum unique roamers from the date 17/03China example

Can you please help me troubleshoot my expression?

Re: Help with an expression?

Andrew_Incite — Tue, 19 Mar 2019 00:58:11 GMT

Have you checked your underlying data to see if anything may be causing duplication? Try previewing the data model to see. The Set Analysis looks ok at first glance but I would put

Date(Max(Date),'DD/MM/YY') and "$(=Date(Max(Date), 'DD/MM/YY'))"

Into a text box to see if it gives you what you expect.

Re: Help with an expression?

rt_new_user — Tue, 19 Mar 2019 04:47:19 GMT

Hi Thanks for your reply.

I have never used a text box expression. Is there a syntax?

Re: Help with an expression?

Shubham_Deshmukh — Tue, 19 Mar 2019 07:21:21 GMT

Hi @rt_new_user ,

Let's make it simpler,

Create Variable : vMaxDate = date(max(Date)) & Dimension : Country

=Sum(if(Date =vMaxDate,Unique_Roamers))

-Shubham

Re: Help with an expression?

Andrew_Incite — Wed, 20 Mar 2019 15:03:47 GMT

Simply create a text box object and put the expressions in there, including the = sign. It is a good troubleshooting technique to make sure whats going into the set analysis is what you expect.