Ad-Hoc Report

[sanjujeeboy]

 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?

[tresesco]

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

[ramasaisaksoft]

Hi Sanju,

hopefully below link will help you.

https://community.qlik.com/t5/QlikView-Layout-Visualizations/How-to-use-conditional-view-with-getfie...