topic Re: IF statement for straight table in QlikView

IF statement for straight table

Mon, 11 Mar 2013 12:10:07 GMT

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)

Re: IF statement for straight table

manideep78 — Mon, 11 Mar 2013 12:13:35 GMT

Try this

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

Re: IF statement for straight table

kaushiknsolanki — Mon, 11 Mar 2013 12:13:56 GMT

Try this,

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

Regards,

Kaushik Solanki

Re: IF statement for straight table

Mon, 11 Mar 2013 12:15:58 GMT

Thanks! It worked