topic expressions help in QlikView

expressions help

surajap123 — Tue, 08 Oct 2013 12:16:33 GMT

Hi Experts,

Could you help me how to write the expressions(using set analysis) for below-

1.select sales from table

where activitydate = today()

2. expression to get % of sales increase or decrease compare to previous day.

Regards,

Suraj

vikasmahajan — Tue, 08 Oct 2013 12:20:00 GMT

=sum( {$< Quarter=,Monthname=, FiscalYear={$(=Max(FiscalYear))}>} Sales) This will current period sales

=sum( {$< Quarter=,Monthname=, FiscalYear={$(=Max(FiscalYear)-1)}>} Sales) This will current period sales

=column(1)-column(2)./column(2) formula for growth %

Hope this helps you.

Vikas

Anonymous — Tue, 08 Oct 2013 15:05:44 GMT

sum({$<activitydate = today() >} Sales)

=num((sum({$<activitydate = date(Today()) >} Sales) - sum({$<activitydate = date(Today()-1) >} Sales)) /

sum({$<activitydate = date(Today()-1) >} Sales),'0.00%')

Hope it helps

BR,

Tue, 08 Oct 2013 15:19:59 GMT

will u please share example data

so i can help more accurately