topic Ad-Hoc Report in QlikView

Ad-Hoc Report

sanjujeeboy — Sat, 16 Nov 2024 21:22:42 GMT

i have to create an ad hoc report

there are two dimensions :

A,B

Measure : C

Measure C has different formula for both dimensions.

output should be such that if i click on A , measure C should come with 1st formula , if B, then measure C should show second formula.

how to acheive this?

Re: Ad-Hoc Report

tresB — Wed, 20 Feb 2019 11:08:41 GMT

If A,B are dimensions and not values of a field, you could probably use conditional expression like:
=GetSelectedCount(A) // for first expression
=GetSelectedCount(B) // for second expression

Re: Ad-Hoc Report

ramasaisaksoft — Thu, 21 Feb 2019 09:32:13 GMT

Hi Sanju,

hopefully below link will help you.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/How-to-use-conditional-view-with-getfieldselections-based-on/td-p/858523