Sales value to be zero

[Anonymous]

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]

Look for I/p Field and what if concept.

Regards

ASHFAQ

[giakoum]

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

http://community.qlikview.com/thread/45050

http://community.qlikview.com/docs/DOC-1852

[Anonymous]

Hi,

I am attaching the app

provide me the solution / approach

[Anonymous]

bump

[giakoum]

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]

I will provide two scenario's

1) 2000Q1 Make it zero and

or

2) EveryQ1's of every year can be Zero

[giakoum]

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.