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: 
sanjujeeboy
Creator
Creator

Ad-Hoc Report

 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?

 

Labels (1)
2 Replies
tresesco
MVP
MVP

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