Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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))