topic Re: Ad-Hoc Report in QlikView

Ad-Hoc Report

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

Hi All,

There are two Measure selections(Measure and NEW) in the report according to which the chart should appear.

the output required:

For any selections in Measure the Total of those columns should appear.

Similarly if any selection from NEW then the Total1 of those columns should also be implemented in the chart.

issue:incorrect total1 and any selection for NEW does not Hide.

Appreciate your effort.Thanks

Regards,

Shreya

Re: Ad-Hoc Report

sunny_talwar — Thu, 27 Dec 2018 15:12:57 GMT

What exactly is the issue? When you don't select anything in NEW... you see all the expressions? Is that what the issue is?

Re: Ad-Hoc Report

shreya_nadkarni — Thu, 27 Dec 2018 15:16:39 GMT

Yes when i dont select anything from NEW i am still able to see expressions from NEW.

Also the Total1 expression RangeSum($(=mid(Concat(',Column(' &ValueLoop(1,$(=Count(NEW)-1))&')' ),2)))

is giving incorrect output.

Thanks

Re: Ad-Hoc Report

sunny_talwar — Thu, 27 Dec 2018 15:23:29 GMT

Try this for total1

RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=Count(Measure)+1),$(=Count(NEW)+Count(Measure)-1))&')' ),2)))

and use this for your NEW expressions

=SubStringCount('|' & Concat(distinct NEW, '|') & '|', '|Z|') and GetSelectedCount(NEW) > 0

Re: Ad-Hoc Report

shreya_nadkarni — Thu, 27 Dec 2018 15:39:47 GMT

the calculation condition for the chart which i have given is an issue

=GetSelectedCount(Dimension) > 0 and GetSelectedCount(Measure) > 0

which means i must select Measure(mandatory).

But the selection can be from any MEASURE OR NEW. or Both

how do i handle that situation.

Thanks.

trying to understand the expression

RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=Count(Measure)+1),$(=Count(NEW)+Count(Measure)-1))&')' ),2)))

how does this work? Thanks

Re: Ad-Hoc Report

sunny_talwar — Thu, 27 Dec 2018 15:43:19 GMT

@shreya_nadkarni wrote:
the calculation condition for the chart which i have given is an issue
=GetSelectedCount(Dimension) > 0 and GetSelectedCount(Measure) > 0
which means i must select Measure(mandatory).
But the selection can be from any MEASURE OR NEW. or Both
how do i handle that situation.

May be try this

=GetSelectedCount(Dimension) > 0 and (GetSelectedCount(Measure) > 0 or GetSelectedCount(NEW) > 0)

@shreya_nadkarni wrote:

trying to understand the expression
RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=Count(Measure)+1),$(=Count(NEW)+Count(Measure)-1))&')' ),2)))
?
how does this work? Thanks

It is ValueLooping from end of Measure expressions till the end....

Re: Ad-Hoc Report

shreya_nadkarni — Thu, 27 Dec 2018 15:49:30 GMT

if nothing is selected from Measure

the REQUIRED OUTPUT chart TOTAL1 is coming incorrect.

Re: Ad-Hoc Report

sunny_talwar — Thu, 27 Dec 2018 16:04:40 GMT

Try this

RangeSum($(=mid(Concat(',Column(' &ValueLoop($(=GetSelectedCount(Measure)+1),$(=GetSelectedCount(NEW)+GetSelectedCount(Measure)-1))&')' ),2)))

Re: Ad-Hoc Report

shreya_nadkarni — Thu, 27 Dec 2018 16:35:08 GMT

Thanks a lot Sunny for all the help.(y) 🙂