topic Re: Logic in QlikView

Logic

Fri, 13 Mar 2015 04:33:28 GMT

Dear All,

I am facing an issue that I have to slow particular expression column for Month only not in the case of week.

I create an group for Month and week in a same field. but i want to right an expression to show Test plan for Month only .

Please find attachment for details..

Re: Logic

agni_gold — Fri, 13 Mar 2015 05:24:16 GMT

Can you please explain , what exacltly do you want to say.

Re: Logic

senpradip007 — Fri, 13 Mar 2015 05:28:18 GMT

Can upload sample qvw?

Re: Logic

Fri, 13 Mar 2015 05:57:44 GMT

Hi,

can you send sample QVW file and data.

Re: Logic

Anonymous — Fri, 13 Mar 2015 06:11:59 GMT

Hi Rahul,

You can identify from you field only based on the length of the substring. when ever length of substring in you newly created field = monthvalue then show test plan.

Hope this helps

Re: Logic

Fri, 13 Mar 2015 08:01:53 GMT

Dear All,

I am facing an issue that I have to slow particular expression column for Month only not in the case of week.

I create an group for Month and week in a same field. but i want to right an expression to show Test plan for Month only

Please find attachment for details..

Present Case
		Group	Feb		20150309		20150310
	Region	State	Sale	Test plan	Sale	Test plan	Sale	Test plan
	East	Assam	10	7941	0	11	0	11
	East	Assam	25	920	-	-	-	-

Required
		Group	Feb		20150309	20150310
	Region	State	Sale	Test plan	Sale	Sale
	East	Assam	10	7941	0	0
	East	Assam	25	920	-	-

Re: Logic

Peter_Cammaert — Fri, 13 Mar 2015 08:25:56 GMT

Create a calculated dimension with expression =ValueList('Sale', 'Test plan')

Merge the two expression into a single one, and enter this in the expression field:

= if (ValueList('Sum', 'Test plan') = 'Sales', sum(Sale), sum([Test plan])

What this does? Expressions in pivot tables cannot be suppressed for different dimension values, except if you turn the expressions into dimension values themselves, and change the expression results into 0 or NULL values for a particular case.

So what you'll need to do as a final step is to set Sales to 0 in the CONCATENATE LOAD for month-based entries.

The result:

YMMV: there are different ways to do this, but the calculated dimension will stay.

Best,

Peter

Re: Logic

Sat, 14 Mar 2015 12:41:56 GMT

Hi rahulyadav

Can You Upload You Qvw file for clear understand of the expression

Re: Logic

Peter_Cammaert — Mon, 16 Mar 2015 07:41:35 GMT

How did it work out?