topic Re: Show only data which changed today in QlikView

Show only data which changed today

Wed, 09 Jul 2014 08:20:40 GMT

Hello,

I have a data set like this :

I want to have a list which shows only the brands which are newly added today (08-07-2014).

The result I expected is :

Brands
Apple

Should I use set analysis or can I use another function ?

I tried above(), but I only get the 'brand' above the one that I selected and not the brand from yesterday.

Thank you.

sasikanth — Wed, 09 Jul 2014 08:29:37 GMT

try some thing like below

Aggr(if(date=Today(),brand),brand)

alexandros17 — Wed, 09 Jul 2014 08:32:42 GMT

Try this formula as dimension in a chart (and add an expression with value = 1)

If(min(date)=max(date) and date=today(), Brands, Null())

let me know

Wed, 09 Jul 2014 08:41:31 GMT

Thank you, it works !