Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Period to display

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.


8 Replies
giakoum
Partner - Master II
Partner - Master II

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

uncheck suppress zero - suppress missing in presentation tab

PrashantSangle

Hi,

try like

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

why there is * after SCENARIO??

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
priyarane
Specialist
Specialist
Author

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.

giakoum
Partner - Master II
Partner - Master II

looks like a data issue. A sample app would help

priyarane
Specialist
Specialist
Author

Hi Ioannis,

even after changes no changes happend.

Could you please suggest another one?

PrashantSangle

Hi,

What is your dimension and expression?

If possible post your sample app..

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
priyarane
Specialist
Specialist
Author

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

priyarane
Specialist
Specialist
Author

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