Thanks all for your reply, unfortunatly i can't get it work.
As you has asked i upload an example file.
In this file you can find two the two charts.
Hope you can help me.
Qliktech_Example_File.qvw 160.2 K
You can use dimension limits if you're using QV11. See attached example. It has an additonal expression that isn't shown as a bar in the chart.
If you have QV10 you could use this as a calculated dimension: =aggr(if(rank(week)<=4,week),week)
Qliktech_Example_File v2.qvw 159.5 K
My apoligies but is still didn't get it.
As written above i have an table:
PeriodID - Year - Quarter - Period - Week
PeriodeID: Identical Key
Quarter: PeriodeQuarter (4 quarters in one year)
Period: Each period is 4 weeks (13 periods in one year)
Week: the weeknumber (52 weeks in one year)
Now i have created a variable value (LaatsteVerwerking4weken=(CEIL(Week(Today())/4)-1) 3
This value is telling QV the Period value i would like to show in the chart (a value from 1 till 13)
So when the 'LaatsteVerwerking4weken' (variable) value is 2 than the chart have to show the weeks within the period 2 of the Period-table.
I'll hope my explenation is clear en you can help me.
Below I added and picture of the tables, variable and the chart I wish.
The yellow fields are the field of the Variable (in this case: 2).
The red fields are the fields (the weeks) i would like to shown in the chart.