Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Set Analysis Help

I have a daily observations of active accounts (activeacnts). I would like to do two things with them.

1. Put activeacnts today in  Text box

2. Plot active accounts on the last day of each month in a line chart.

I tried to use set analysis to accomplish this but I cant seem to understand the formatting requirements. e.g. For today's activeacnts I did this

Sum({$<Date= {'=Date(Today())'}>}activeacnts)

It gives me sum of all the active accounts instead of active accounts Today. if I write

Sum({$<Date= {'8/2/2012'}>}activeacnts)

Then I get correct answer.

Similarly when i create Expression to plot monthend active accounts I get weird numbers on the line chart. I am not able to understand what's going wrong.

1 Solution

Accepted Solutions

Re: Set Analysis Help

Hi

     Your date format is 'M/D/YYYY' ? If so, you can use like this,

      =Sum({$<Date= {"$(=Date(Today(),'M/D/YYYY'))"}>}activeacnts)

     I think ,your format is MM/DD/YYYY only..

      =Sum({$<Date= {"$(=Date(Today(),'MM/DD/YYYY'))"}>}activeacnts)

     Hope it helps

4 Replies

Re: Set Analysis Help

Hi

     Try like  this

     =Sum({$<Date= {'$(Date(Today()))'}>}activeacnts)

     But make sure the format. Date(Today(),'MM/DD/YYYY')

     Hope it helps

Highlighted
Not applicable

Re: Set Analysis Help

How to make sure of that, Mayil? I think my date format by default is 'M/D/YYYY'

Re: Set Analysis Help

Hi Samarth,

    Try this.

      =Sum({$<Date= {"$(=Date(Today(),'MM/DD/YYYY'))"}>}activeacnts)

    Hope this will Help.   

Regards,

Kaushik Solanki

Re: Set Analysis Help

Hi

     Your date format is 'M/D/YYYY' ? If so, you can use like this,

      =Sum({$<Date= {"$(=Date(Today(),'M/D/YYYY'))"}>}activeacnts)

     I think ,your format is MM/DD/YYYY only..

      =Sum({$<Date= {"$(=Date(Today(),'MM/DD/YYYY'))"}>}activeacnts)

     Hope it helps

Community Browser