topic Re: Period to display in QlikView

Period to display

priyarane — Mon, 30 Mar 2015 09:37:56 GMT

Hi Experts,

I want show P0 values also.

please see the attachments to get clear idea.

Chart1- explains my chart without selections(clear all - no filter)

Chart2- when I make selection Scenario S1, Then P0 is missing.

expression:

sum( {<SCENARIO*={'S1','JUMP-OFF'}>} RWA)

Note : 'JUMP-OFF' - means P0.

So my requirement is ex: if select Scenario S1, then also P0 values should display.

means- Chart2(attachment) with P0 values

thank you.

Re: Period to display

giakoum — Mon, 30 Mar 2015 09:40:38 GMT

it is missing because there is no data for it I guess

uncheck suppress zero - suppress missing in presentation tab

Re: Period to display

PrashantSangle — Mon, 30 Mar 2015 09:40:50 GMT

Hi,

try like

sum( {<SCENARIO={'S1','JUMP-OFF'},period=>} RWA)

why there is * after SCENARIO??

Regards

Re: Period to display

priyarane — Mon, 30 Mar 2015 09:51:06 GMT

Hi Max,

This is my actual requiremetn -
//sum(if(SCENARIO='S1'or SCENARIO = 'JUMP-OFF' ,RWA))
so I have changed to Setanalysis - sum( {<SCENARIO={'S1','JUMP-OFF'}RWA)

Even after using your expression

sum( {<SCENARIO={'S1','JUMP-OFF'},period=>} RWA)

No changes happend. still no P0 values.

Re: Period to display

giakoum — Mon, 30 Mar 2015 09:52:07 GMT

looks like a data issue. A sample app would help

Re: Period to display

priyarane — Mon, 30 Mar 2015 09:53:20 GMT

Hi Ioannis,

even after changes no changes happend.

Could you please suggest another one?

Re: Period to display

PrashantSangle — Mon, 30 Mar 2015 09:56:31 GMT

Hi,

What is your dimension and expression?

If possible post your sample app..

Regards,

Re: Period to display

priyarane — Mon, 30 Mar 2015 09:59:08 GMT

Hi Max,

I got it, I have checked show all values option under Dimensions tab, now I can see all the values. Thanks for your reply Max

Re: Period to display

priyarane — Mon, 30 Mar 2015 10:00:00 GMT

Hi Ioannis,

I got it, I have checked show all values option under Dimensions tab, now I can see all the values. Thanks for your reply Ioannis