topic Re: Sales value to be zero in QlikView

Sales value to be zero

Anonymous — Tue, 30 Sep 2014 11:37:15 GMT

Hi,

I have the year and Quarter wise sales and I need the values of particular year sales to be 0 with out hardcode

ashfaq_haseeb — Tue, 30 Sep 2014 11:39:17 GMT

Look for I/p Field and what if concept.

Regards

ASHFAQ

giakoum — Tue, 30 Sep 2014 11:41:48 GMT

you may use dynamic updates for that, but what is exactly the requirement? Maybe we can help suggest some other way

Anonymous — Tue, 30 Sep 2014 11:59:45 GMT

Hi,

I am attaching the app

provide me the solution / approach

Anonymous — Tue, 30 Sep 2014 12:35:47 GMT

bump

giakoum — Tue, 30 Sep 2014 12:40:39 GMT

you need to be more detailed. Who decides which quarters should be zero and why? Should it be a list the user selects from?

Anonymous — Tue, 30 Sep 2014 12:55:18 GMT

I will provide two scenario's

1) 2000Q1 Make it zero and

2) EveryQ1's of every year can be Zero

giakoum — Tue, 30 Sep 2014 13:08:22 GMT

Still not replying why you need it but I will not insist on that longer.

In my mind, if it is the developer who needs to do that then it should be done in the reload script i.e.

if(right(quarter, 2) = 'Q1', 0, sales) as sales

or similar.

If it is the user, they should fix their data in the source not in QlikView. QlikView is BI not front office system.

If that is for any reason not possible, then dynamic updates can be used. See attached example.