topic Re: Conditional Values in Null in QlikView

Conditional Values in Null

renuka_sasikumar — Thu, 10 Mar 2016 09:29:59 GMT

Hi,

I have two chart as below

Here I have hard cored for Offline_MF as if(Source='Direct','XXXX').

The same value I want in Zone wise but under NA. Is this possible can anyone help me.

Regards,

Renuka S

Gysbert_Wassenaar — Thu, 10 Mar 2016 09:32:44 GMT

I don't understand the problem? Can you explain what's stopping you from hard coding Offline_MF as XXXX for NA?

mightyqlikers — Thu, 10 Mar 2016 09:33:03 GMT

hi,

could you post with sample data and required output.

Regards

renuka_sasikumar — Thu, 10 Mar 2016 09:47:33 GMT

Thanks for your prompt reply

Check it out the attached app

I want the value in Zonewise under NA

Regards,

Renuka S

Gysbert_Wassenaar — Thu, 10 Mar 2016 09:52:38 GMT

There is no NA in your data. Your document makes no sense at all to me.

renuka_sasikumar — Thu, 10 Mar 2016 09:57:29 GMT

There is no NA but I want to show as NA in Zonewise.

I have attached the sample data, here I have much data but which is very much confidential.

Gysbert_Wassenaar — Thu, 10 Mar 2016 10:00:19 GMT

You can't show things that do not exist.

MayilVahanan — Thu, 10 Mar 2016 10:09:34 GMT

PFA

renuka_sasikumar — Thu, 10 Mar 2016 10:13:05 GMT

Thank you MAYIL VAHANAN RAMASAMY

xavieravinson — Mon, 14 Mar 2016 11:45:05 GMT

Hi Renu,

Please mail me the answer.

renuka_sasikumar — Tue, 15 Mar 2016 08:50:56 GMT

Hi,

Check the attachment attached by MAYIL VAHANAN RAMASAMY