topic Re: Show Budject count as on in QlikView

Show Budject count as on

Anonymous — Wed, 30 Mar 2016 12:40:11 GMT

Hi All,

I have a requirement to show the below scenario in Text Object. Could you please help me.

Scenario:

In the Text Object, I want to show Budject count as on.

The requirement is if you select Quarter or Month it will display corresponding Quarter and Month.

if you don't make any selection it will display as on .

I used this code:

=if(Quarter='Q4',Round(sum(Number)),
if(GetSelectedCount(Quarter) > 0,Round(sum(Number)/3),
if(GetSelectedCount(month) > 0,sum(Number),
Sum({<m ={'03-01-2016'}>}Number))))

it is working. But I need simple code with dynamically changing by Quarter and Month. Pls find attached qvw.

Thanks,

Krishna

Re: Show Budject count as on

sunny_talwar — Wed, 30 Mar 2016 12:42:00 GMT

Dynamic based on what? selection in m?

Re: Show Budject count as on

sunny_talwar — Wed, 30 Mar 2016 12:43:16 GMT

May be this?

=if(Quarter='Q4',Round(sum(Number)),

if(GetSelectedCount(Quarter) > 0,Round(sum(Number)/3),

if(GetSelectedCount(month) > 0,sum(Number),

Sum({<m ={"$(=Date(Max(m), 'MM-DD-YYYY'))"}>}Number))))

Re: Show Budject count as on

Anonymous — Wed, 30 Mar 2016 12:48:24 GMT

Hi Sunny,

The requirement is if you select Quarter or Month it will display corresponding Quarter and Month.

if you don't make any selection it will display as on .

Re: Show Budject count as on

Anonymous — Wed, 30 Mar 2016 12:52:47 GMT

Hi Sunny,,

=if(Quarter='Q4',Round(sum(Number)),

if(GetSelectedCount(Quarter) > 0,Round(sum(Number)/3),

if(GetSelectedCount(month) > 0,sum(Number),

Sum({<m ={"$(=Date(Max(m), 'MM-DD-YYYY'))"}>}Number))))

Your code is working fine. how can i change Quarter Dynamically(Q4)

Thanks,

Krishna.

Re: Show Budject count as on

sunny_talwar — Wed, 30 Mar 2016 12:56:17 GMT

Krishna,

I am having difficultly understanding your if condition. What exactly do you want to see when Quarter is selected and when Month is selected? and What happens when both are selected?