Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MK9885
Master II
Master II

Remove columns with 0 as value in Dimension/measures not supress values etc

Hi,

I have a requirement to group a measure into 2

I got single dimension as YearMonth

2 measures, one is for Amount A and another is for Amount B

From Jan to June there are values for Amount A

From July to Dec, values for Amount B

Since I'm using 1 dimension which will span from Jan to Dec...

2 columns are made Jan will have value for A but 0 for B

I want to eliminate the column where ever it is 0.

stalwar1

2 Replies
Anil_Babu_Samineni

Can be possible, But how you analyze that? Let's assume

Load * Inline [

YearMonth, Amount A, Amount B

Jan, 60,

Feb, 50,

Mar, 40,

Apr, 30,

May, 20,

Jun, 10,

Jul, , 60

Aug, , 50

Sep, , 40

Oct, , 30

Nov, , 20

Dec, , 10

];

This is the case, What you want in chart?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MK9885
Master II
Master II
Author

Sorry I did not understand this...

I'm using Single measure for now and Single Dimension

Jan to July has my current Amount

Aug to Dec has my Forecast Amount

I get correct values for this

when I use 2nd measure by using a filter in set analysis it gives me 0 for Forecast Amount from Jan to Jul

and 0 for Current amount from Aug to Dec

Below is my expression....

Sum (Amount) --- Current Single Expression

Trying to add new expression

Sum(CurrentAmount)

Sum(ForecastAmount)

I used Set analysis filter like CurrentAmount-={0} did not work

Tried Aggr for dimension did not work...

Any help would be appreciated.

Thanks.