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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
GregWP
Contributor II
Contributor II

Continuous X axis for [Year Month]

I'm trying to create a monthly bar chart that includes months where there were no transactions. The continuous scale option seems to only work for date fields.

I tried using variations of this:

Aggr( MaxString({1<PRNT_PROJ_NO=,[Year Month]={">=$(=Min([Year Month]))<=$(=Max([Year Month]))"}>} [Year Month]), [Year Month])

including using  Aggr({$<[Year Month]=P({1}[Year Month])>}  

While I can see in a Filter Pane it actually generates the full set of records I can't get it to work in a table because the missing months are grey. I'm including null & zero values in my options.

(I was selecting on Parent Project but there is a project hierarchy to consider)

 

All ideas appreciated.

0 Replies