topic Re: Condition in QlikView

Condition

deepakqlikview_123 — Fri, 18 Jul 2014 09:16:16 GMT

Hi All,

Please find attached screenshot and QVD .

I am using condition only

capitalize( ModelHead) as [Model Head],

I want to replace - by City 200 AF.

Please suggest

Thanks

Re: Condition

alexandros17 — Fri, 18 Jul 2014 09:20:30 GMT

Generally if you see - the reason is that there are null values so you must check data relation.

Attach your document if you can and I'll take a look

Re: Condition

sudeepkm — Fri, 18 Jul 2014 09:31:42 GMT

you can use isnull() function or something like below.

if (len(ModelHead)>0,capitalize( ModelHead),'City 200 AF') as [Model Head]

Re: Condition

Anonymous — Fri, 18 Jul 2014 09:34:53 GMT

Try something like

if ( isnull ( [ModelHead] ) , 'City 200 AF' , [ModelHead] )

Re: Condition

Anonymous — Fri, 18 Jul 2014 09:37:09 GMT

...... or on the Presentation tab of your chart for the Null Symbol replace the - with what you want.

Re: Condition

deepakqlikview_123 — Fri, 18 Jul 2014 09:38:01 GMT

Can you please give me screenshot for the same for making changes.

thanks,

Deepak

Re: Condition

Anonymous — Fri, 18 Jul 2014 09:40:26 GMT

I am sure you can find the Presentation tab of your chart without a screen shot, Null Symbol is then in the bottom left hand corner.

Re: Condition

deepakqlikview_123 — Fri, 18 Jul 2014 09:44:51 GMT

HiBill,

Still i am not able to find it, please suggest.

Thanks

Re: Condition

sudeepkm — Fri, 18 Jul 2014 09:44:51 GMT

can you please share the qvw you are using or the chart expression and dimensions as per your screenshot.

As I could not find any null entries when I loaded data from your QVD for ModelHead.

In your screenshot the Model Head looks like a Drill Group. Can you please give some more detail.

Re: Condition

deepakqlikview_123 — Fri, 18 Jul 2014 09:47:24 GMT

Hi sudeep,

As application size is too huge i am not able to share

QVW file with u.I am using drill grp in following hierarchy,

Model head-fuel used-Vehicle type,Model name.

Thanks

Re: Condition

sudeepkm — Fri, 18 Jul 2014 09:56:55 GMT

These are the fields what I see in the qvd.

As per you Model head-fuel used-Vehicle type,Model name is the group.

Are you referring to FuelType as fuel used and i do not see a Vehicle type and the Model Name you mean Model Type ? Please clarify and what is the expression in your chart. is it count(ID) or something else.

Re: Condition

deepakqlikview_123 — Fri, 18 Jul 2014 09:58:39 GMT

Hi Sudeep ,

i am using,

count( if(IsCancelled = '0',ChassisNumber))

Thanks

Re: Condition

Fri, 18 Jul 2014 10:02:16 GMT

Hi,

Use the following as your dimension:

if(isnull(ModelHead), 'City 200 AF', Capitalize(ModelHead))

Regards

Rahul

Re: Condition

sudeepkm — Fri, 18 Jul 2014 10:04:22 GMT

the field ChassisNumber and IsCancelled are not present in the QVD. it looks like you have other tables which are not provided here.

Re: Condition

sudeepkm — Fri, 18 Jul 2014 10:06:10 GMT

try reduce load like 1000 records or so and you can also scramble the data and then you can share. it will be of small size. without looking at all the fields used in the chart it is difficult to suggest a solution.

Re: Condition

deepakqlikview_123 — Fri, 18 Jul 2014 10:06:55 GMT

Hi Sudeep,

ChassNumber is in my fact table.

That is diff table.

As size is too big I am not able to upload data.

thanks,

Re: Re: Condition

deepakqlikview_123 — Fri, 18 Jul 2014 10:27:03 GMT

Hi Sudeep,

Please find attached Retail Qvd,

Thanks

Re: Re: Condition

deepakqlikview_123 — Fri, 18 Jul 2014 11:54:03 GMT

Hello all issue has been resoled,

I have applied below formula

=if(isnull([Model Head]),'City 200AF',[Model Head]).

On dimension.

thanks