topic Start date and end date problem in Calendar in QlikView

Start date and end date problem in Calendar

saumyashah90 — Mon, 04 Mar 2013 10:31:53 GMT

I created two variables of start_date and end_date and den choosed two calendar objects in which for variable

start_date i kept min value=Min(Date) & max value=Max(Date) and for end_date i kept min value=Date($(start_date)) & max value=Max(Date)

Now i have a mini chart consisting of trend lines and pictures

Avg({<Date={'>=$(start_date)&<=$(end_date)'}>} [Metric Value])

It stopped showing n y thing in that column

same thing for the trend line.

Tell me what to write for expressions which already have 3 if conditions in it

Gysbert_Wassenaar — Mon, 04 Mar 2013 10:50:29 GMT

Remove the & from the expression:

Avg({<Date={'>=$(start_date)<=$(end_date)'}>} [Metric Value])

saumyashah90 — Mon, 04 Mar 2013 11:09:28 GMT

If in expression i have

=Num(Sum({<[Sub Dept]={'PWM'}>} [Metrics Value]))

How to put date condition?

saumyashah90 — Mon, 04 Mar 2013 11:26:24 GMT

Hey its not showing error but now nothing changes in chart according to change in dates in calendar..?what to do?

=if([Sub Dept]='Equity',sum([Metric Value])).....???

and what if like this there are three if condition..??