Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF statement for straight table

Hi,

I need to display a value in a straight table for one specific value. I have Date as dimension and Rating as expression in a table.

I only need to show Rating for Company A at all times ignoring any other selections that the user makes. So if the user selects Company B, the table should still show Company A Rating. I have this but it only works if Company A or nothing at all is selected:

if([Company] = 'Company A', RATING)

1 Solution

Accepted Solutions
Partner
Partner

Try this

Only({1<Company={'Company A'}>}RATING)

View solution in original post

3 Replies
Partner
Partner

Try this

Only({1<Company={'Company A'}>}RATING)

View solution in original post

MVP & Luminary
MVP & Luminary

Try this,

Sum({1<Company = {"Company A"}>}Rating)

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Not applicable

Thanks! It worked