Uregent

[#1]

Hi Qlikies,

i have two dimensions Week and Quarter and one expression sum(Quantity)...now my requirement is:

If i open the chart it shows Quarter Bar chart, but i want to show weeks if anyone clicks on a single Quarter Bar for that particular Quarter.

thanks in advance,

Bharath

[its_anandrjs]

Use getfieldselection(Quarter) function

[Colin-Albert · Accepted solution]

Use a drill-down group with Quarters and Weeks.

Look at Edit Groups on the Dimensions tab of your chart

[#4]

Create the drill down group with hierarchy Quarter --> Week.

So whenever u l select any quarter it will show only weeks related to that quarter.

Hope this will help u..!

[vipin_mishra479]

Hi Bharath,

PFA

[its_anandrjs]

Or you can use =GetSelectedCount(QuarterField)=1 also

Try with take straight table

Dimension:- Week (And on week dimension click on enable conditional write expression like =GetSelectedCount(YourQuarterFieldHere) = 1

Dimension:- Quarter

Expression:- sum(Quantity)

[#7]

Drill down group is the easiest solution

[#8]

you can also use restrication on the dimensions quarter use getselectedcount(quarter) > 1 and for week use getselectedcount(quarter) = 1

I hope this helps.

regards,

MT

[#9]

Awesome response.

Thank you all..