topic Set analysis task in QlikView

Set analysis task

Wed, 29 Jul 2015 09:43:21 GMT

Based on calendar object selections...it will show all years in one bar chart and it will show particular years in another bar chart.

for example if i select 2011 in calendar object ...in one bar chart all months should be appear and in another bar chart jan,feb,march,dec..these particular moths should be appeared.

Re: Set analysis task

Gysbert_Wassenaar — Wed, 29 Jul 2015 09:46:51 GMT

In the chart that should show all years change the expressions to overrule the selections in the year field. For example sum(Sales) would become sum({<Year=>}Sales) if you want to ignore selections in the field Year. Sum({1}Sales) would ignore selections in all fields.

Re: Set analysis task

sushil353 — Wed, 29 Jul 2015 09:48:02 GMT

Hi,

you can use drill down option in dimension.

Create a drill down group for Year and Month and then use that drill down dimension in dimension.

HTH

Sushil

Re: Set analysis task

Anonymous — Wed, 29 Jul 2015 09:49:37 GMT

the second Chart should use a calculated dimension

if (Macht(monthfield,'jan','feb','march','dec')>1,monthfield)

why do you want those specific months?

maybe a flag would be easier to hanlde in script?