Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shreya_nadkarni
Partner - Creator
Partner - Creator

Ad-Hoc Report

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

 

1 Solution

Accepted Solutions
sunny_talwar

Try this

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

View solution in original post

8 Replies
sunny_talwar

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

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

sunny_talwar

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
shreya_nadkarni
Partner - Creator
Partner - Creator
Author

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

 

sunny_talwar


@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....

shreya_nadkarni
Partner - Creator
Partner - Creator
Author

if nothing is selected from Measure

the REQUIRED OUTPUT chart TOTAL1 is coming incorrect.

sunny_talwar

Try this

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

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