Qlik set analysis

[MeeraAgrawal]

Hi Guys 

The below expression throwing an error

if(dc_summary_dropdown[Graph2]="Number of Stores", Sum([dc_instance.NUMBER_OF_DESTINATIONS]),
If(dc_summary_dropdown[Graph2]="Outbound Volume (Pallets)", Sum([dc_instance.QUANTITY_SHIPPED]),
Sum([dc_instance.AVERAGE_OUTBOUND_DISTANCE])))

Please  help me.

[MeeraAgrawal]

Nobody is here to give me an answer

[Anil_Babu_Samineni · Accepted solution]

Here double quotes can prevent as field, If you mean the field name you must use single quote like

if(dc_summary_dropdown[Graph2]='Number of Stores', Sum([dc_instance.NUMBER_OF_DESTINATIONS]),
If(dc_summary_dropdown[Graph2]='Outbound Volume (Pallets)', Sum([dc_instance.QUANTITY_SHIPPED]),
Sum([dc_instance.AVERAGE_OUTBOUND_DISTANCE])))

[MeeraAgrawal · Accepted solution]

Thanks your prompt response but I resolved it by write it like

if([Graph2]='Number of Stores', Sum([dc_instance.NUMBER_OF_DESTINATIONS]),If([Graph2]='Outbound Volume (Pallets)', Sum([dc_instance.QUANTITY_SHIPPED]),Sum([dc_instance.AVERAGE_OUTBOUND_DISTANCE])))

[Anil_Babu_Samineni]

LOL, You changed field itself. Great !!

[MeeraAgrawal]

Hi @Anil_Babu_Samineni 

I didn't changed field I removed table name associated with field name only.