topic Re: Dynamic data show with report format in QlikView

Dynamic data show with report format

qlikviewwizard — Mon, 01 Jun 2015 12:56:18 GMT

Hi All,

I have created a report. But when I select the Quarter2 it should show Q1 and Q2 data.

Quarter3 it should show Q1 ,Q2 and Q3 data.

Quarter4 it should show Q1 ,Q2 ,Q3,Q4 data.

Please help.

Thanks in advance.

Re: Dynamic data show with report format

alexandros17 — Mon, 01 Jun 2015 12:58:26 GMT

Remove quarter from your dimension and add in your expression the condition (with set analysis)

{$ <Quarter = {'<=GetFieldSelections(quarter)'}>}

let me know

Re: Dynamic data show with report format

maxgro — Mon, 01 Jun 2015 13:02:50 GMT

=aggr(Sum({<Year=,Quarter={"<=$(=vMaxQtr)"}>} Sal),EmpNo)

Re: Dynamic data show with report format

qlikviewwizard — Mon, 01 Jun 2015 13:03:22 GMT

Hi Alexandros17 ,

Kindly provide the app.

Re: Dynamic data show with report format

qlikviewwizard — Mon, 01 Jun 2015 13:07:02 GMT

Hi maxgro,

I used that formula. But it is showing only selected Quarter. But I want to show Qn consequently (Qn-1,Qn-2,..) for the selection of Qn.

Kindly provide the app.

Thanks in advance.

Re: Dynamic data show with report format

maxgro — Mon, 01 Jun 2015 13:16:18 GMT

I've just replaced your expression in your chart under problem with

=aggr(Sum({<Year=,Quarter={"<=$(=vMaxQtr)"}>} Sal),EmpNo)

and this is the result

Re: Dynamic data show with report format

qlikviewwizard — Mon, 01 Jun 2015 13:27:14 GMT

Hi Massimo Grossi,

I can see only Quarter 4. But I need to show Q1,Q2,Q3,Q4 in the report as we have selected Q4.

Please provide the app.

Like This:

Re: Dynamic data show with report format

maxgro — Mon, 01 Jun 2015 13:44:04 GMT

I think a simple solution could be: 4 expression (as quarters are 4)

=aggr(Sum({<Quarter={1}>} Sal),EmpNo)

...

=aggr(Sum({<Quarter={1,2,3,4}>} Sal),EmpNo)

conditional show

for first expression max(Quarter)>=1

....

4th max(Quarter)>=4

Re: Dynamic data show with report format

alexandros17 — Mon, 01 Jun 2015 14:05:00 GMT

Here it is

Re: Dynamic data show with report format

jagan — Tue, 02 Jun 2015 05:25:46 GMT

Hi,

Try like this

=Sum({<Year=, Quarter=, Month=,BillingDate={'>=$(=vStartDate)<=$(=vMaxDate)'}>} Sales)

WHERE

vStartDate = YearStart(Max(BillingDate))

vMaxDate = Date(Max(BillingDate))

Hope this helps you.

Regards,

Jagan.

Re: Dynamic data show with report format

jagan — Tue, 02 Jun 2015 05:26:14 GMT

Year=, Quarter=, Month=

This will ignore selections of those fields.

Regards,

Jagan.