Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator II
Creator II

How to make expression work depending on dimension condition ?

Hi All ,

How can I get the correct CMH_TARGETS.dealer_type depending on Ariticle Condition . ?

For eg ,

on the below image ,

Ariticle Condition Used will have CMH_TARGETS.dealer_type as Used and CMH_TARGETS.apu value as 10000

Ariticle Condition New will have CMH_TARGETS.dealer_type as Luxury and CMH_TARGETS.apu value as 16000 .


Capture.PNG


it can be possible for other dealership ,

Ariticle Condition Used will have CMH_TARGETS.dealer_type as Used and CMH_TARGETS.apu value as 10000

Ariticle Condition New will have CMH_TARGETS.dealer_type as New and CMH_TARGETS.apu value as 12800


Capture1.PNG

sample model attached.

Thanks,

1 Solution

Accepted Solutions
sunny_talwar

May be this?

If(Deal.articleCondition = 'Used',

Only({<CMH_TARGETS.dealer_type = {'Used'}>} CMH_TARGETS.apu),

Only({<CMH_TARGETS.dealer_type -= {'Used'}>} CMH_TARGETS.apu))

View solution in original post

1 Reply
sunny_talwar

May be this?

If(Deal.articleCondition = 'Used',

Only({<CMH_TARGETS.dealer_type = {'Used'}>} CMH_TARGETS.apu),

Only({<CMH_TARGETS.dealer_type -= {'Used'}>} CMH_TARGETS.apu))