topic Re: Uregent in QlikView

Uregent

Wed, 21 May 2014 10:17:28 GMT

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 — Wed, 21 May 2014 10:20:41 GMT

Use getfieldselection(Quarter) function

Colin-Albert — Wed, 21 May 2014 10:22:57 GMT

Use a drill-down group with Quarters and Weeks.

Look at Edit Groups on the Dimensions tab of your chart

Wed, 21 May 2014 10:25:30 GMT

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 — Wed, 21 May 2014 10:32:27 GMT

Hi Bharath,

PFA

its_anandrjs — Wed, 21 May 2014 10:40:05 GMT

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)

Wed, 21 May 2014 10:49:29 GMT

Drill down group is the easiest solution

Wed, 21 May 2014 10:55:43 GMT

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,

Wed, 21 May 2014 10:56:23 GMT

Awesome response.

Thank you all..