topic Re: Detail report in QlikView

Detail report

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am facing one issue.

I have 2 charts..

one is aggregated data based on Category.

and based on start and end selection, populating report.

second one is detailed report, category and subcat and so on..

Example:

1st report..

My detail report also should be same amount based these particular Categories..

in 1st report BCA=10590.

In summarized report only one record 10,000.. it should be 2 records

one for 10,000 and another 590.

PFA,

Thanks in Advance

Re: Detail report

robert_mika — Sat, 14 May 2016 04:39:14 GMT

If you clear the Range, that will show both values.

I believe this id down to the way your variable works

Re: Detail report

paulwalker — Sat, 14 May 2016 17:50:27 GMT

HI Robert,

When i am clear ranges working fine for me.

But users want to export summarized report, based on selection ranges.

Re: Detail report

Anonymous — Sat, 14 May 2016 21:30:48 GMT

Hi Paul,

Here is my suggestion, process the Category in your scripting instead of your dimension:

You will have to change the calculated dimension for Cat fiel in your Amount table. Now, in your detail report you could add an expression like the following one to show only those categories that meet your filter criteria:

=IF(vMin='--Select--' and vMax='--Select--',Cat,

IF(Aggr(Sum(Amount), Cat) >=vMin and vMax='--Select--', Cat,

if(Aggr(Sum(Amount), Cat) >= vMin and Aggr(Sum(Amount), Cat) <=vMax,Cat)))

And check the suppress when value is null option to display only the records with a value

And in your expressions, just add:

=sum(Amount)

With this you will get the following output:

Please check the attached file.

-- Karla

Re: Detail report

sunny_talwar — Sun, 15 May 2016 04:14:04 GMT

Paul -

You can try the following expressions:

Amount:

IF(vMin='--Select--' and vMax='--Select--', Sum(Amount),

IF(Sum(TOTAL <Cat> Amount)>=vMin and vMax='--Select--', Sum(Amount),

IF(Sum(Amount)>=vMin and Sum(Amount)<=vMax, Sum(Amount))))

%Age:

IF(vMin='--Select--' and vMax='--Select--', Sum(Amount)/sum(TOTAL Amount),

IF(Sum(TOTAL <Cat> Amount)>=vMin and vMax='--Select--', Sum(Amount)/sum(TOTAL Amount),

IF(Sum(Amount)>=vMin and Sum(Amount)<=vMax, Sum(Amount)/sum(TOTAL Amount))))