Display String based on conditional Statement.

[berryandcherry6]

Hi,

I need to display String 'TRD' based on conditional Statement (If Statement) in table.

My expression is : if(sum(sales)=0,'TRD',sum(sales))

But it shows nothing. How could i display string in Table.

Regards,

Supriya

[Chanty4u]

Hi,

your expression is working for me.

[jayaseelan]

Hi Supriya,

      if(sum(sales)=0,'TRD',sum(sales))  this expression is working fine. I think there is problem on your data. make verify the sum(sales) = 0 is available.

Thanks,

[berryandcherry6]

Hi,

Its Strange, if i use simply like that its working, but if i use as below

Num(if(Metrics='Invitations',if(count({$<DateType= {'invitation'},

client_id={'15'}>} invitation_id)=0,'TRD',9)),if(Metrics='Completions Rate','#,##0.0%',if(Metrics='Revenue', '$ #,##0.00')))

It gives me '-' (hyphen). Its because of Using Num. What could i do for this?

[jayaseelan]

Except Num conversion  Did you got your desired output? ?

Please upload example qvf file for more clarity.

[Chanty4u]

try to check the  expression in text object. by that  you will get to know where your wrong.

[berryandcherry6]

HI,

Here according to my data: if(count({$<DateType= {'invitation'},client_id={'15'}>} invitation_id) = 0

This gives me 'Value' in textbox.

if(count({$<DateType= {'invitation'},client_id={'15'}>} invitation_id)=0,'Value',9)

But this doesnot, It gives empty or blank

Num(if(count({$<DateType= {'invitation'},client_id={'15'}>} invitation_id)=0,'Value',9),'#,##0.0%')

Its because i am applying Num format in my equation

[berryandcherry6]

HI,

Yes, Except  Num conversion i am getting desired output

[sasiparupudi1]

The reason for this is you are returning strings as input to the num function.

Num is a formatting function .You can not input format as a number as you are doing in your if conditions

qlik Help->Num( A, '#,##0.0%')    where A=35648.375