Hi,

[#1]

i have a problem in Qlik View,

the task is, we have dimensions year,month,date,week and metric/fact is revenue.

we have taken year in list box and the week,month and date in bar charts.

when we select the year in the list box the week month and year should change accordingly.

But when we select month only the date chart should change  and week should not be changed.

so can you help me out with a solution.

we need an expression to connect month and date charts

Thanks,

Sriram

[oknotsen]

Not sure what you are trying to do.

If you select a month, of course the weeks will change as not every week is part of every month (example: week 1 is not part of the month August).

However, your description makes me believe you have something else in mind.

Try this:

sum({ < Week= > } revenue)

or

sum({ < Month= > } revenue)

(depending on what you had in mind)

If that did not solve your problem, could you please give us some example data while you explain what you are trying to do?