Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlikview community,
I have a special question concerning pivot tables an the graphical visualization of them.
I do have a dataset, which looks as follows:
fallnr | DRG_2010 | DRG_2011 | D_CW
fallnr1 | I21Z | I21Z | 0,300
fallnr2 | I21Z | I31Z | 0,500
fallnr3 | I13D | I13C | 0,200
When I put this data into a pivot table, I get something like this:
As you can see, there ist for every DRG 2010 a record, which tells you, which DRG 2011 there is and how many of them.
Now I wanted to have that in a bar chart similar to a pivot chart in Excel. But what I get is this:
The information from the pivot chart is fully transfered to the bar chart. But it shows additionally all DRG_2011 records, that have no correlation to DRG_2010. The pivot chart does not eliminate the values, that are zero or do not have a correlation.
I already tried to check and uncheck the "do not show NULL values" but that did not help.
What I wanted to have is something similar to a pivot chart in excel like this:
As you can see, there are both dimensions shown in one axis and there are no records, which values are zero or null.
Do you have any suggestions, how to get this problem solved?
Thank you very much for any help,
Karsten
Accepted Solutions
I would use a Calculated Dimension something along the lines of "=DRG_2011 & chr(10) & DRG_2010".
As a bonus, you could define the Background Color of the Expression as some RGB manipulation to group the DRG_2010 items together. I used =RGB(100*Mid(DRG_2010,2,1),mod(100*Mid(DRG_2010,3,1),255),mod(10*ord(Mid(DRG_2010,4,1)),255)) to group the I06 as blue, I09 as green, I10 as purple, etc.
I would use a Calculated Dimension something along the lines of "=DRG_2011 & chr(10) & DRG_2010".
As a bonus, you could define the Background Color of the Expression as some RGB manipulation to group the DRG_2010 items together. I used =RGB(100*Mid(DRG_2010,2,1),mod(100*Mid(DRG_2010,3,1),255),mod(10*ord(Mid(DRG_2010,4,1)),255)) to group the I06 as blue, I09 as green, I10 as purple, etc.