topic Re: Can I create a dimension based on measures only? in QlikView

Can I create a dimension based on measures only?

Anonymous — Mon, 23 Nov 2015 09:43:14 GMT

I have:

January Revenue

February Revenue

March Revenue and all the way to December Revenue. So, twelve measures. However, I don't have a dimension with month, so that I could have created a chart to show my measures by month.

What are my options?

Thanks in advance.

Re: Can I create a dimension based on measures only?

effinty2112 — Mon, 23 Nov 2015 21:23:28 GMT

Hi Pawel,

You have one dimension, month, of which you have twelve values, Jan to Dec. You have one measure, the sum of revenues. The way your data looks right now may it not resemble what I say but I'm sure we can knock it into shape and then get a chart.

Can you post your data and we'll have a go?

Cheers

Re: Can I create a dimension based on measures only?

sunny_talwar — Mon, 23 Nov 2015 21:26:08 GMT

Have you considered using CrossTable() load to fix your data in the back end? It can save you a lot of time when creating charts such as the one you just described.

Re: Can I create a dimension based on measures only?

Anonymous — Mon, 23 Nov 2015 21:38:10 GMT

Hi Andrew,

I do have dimension month, however it is showing only one month -> october.

What I did, I pulled revenue by month from one source. So, I have twelve separate measures. Each of them showing revenue for each month. In order to create a chart, i need to assign/create
"January" to Jan-14 Rev and etc. And then group this newly created "Months" under single dimension, which i may use in chart.

Re: Can I create a dimension based on measures only?

effinty2112 — Mon, 23 Nov 2015 22:38:46 GMT

Hi Pavel,

I made an excel file from the image of your data. It's the same as the table you showed only with the two leftmost columns and the top row removed.

This is the script created in the qvw by stepping through the file wizard and transposing the table. I hand edited the first line to extract the month name.

Data:

LOAD Left(@1,3) as Month,

@2 as Revenue

FROM

Data.xlsx

(ooxml, no labels, table is Sheet1, filters(

Transpose()

));

I thoroughly recommend you using the File Wizard with as many different data files as you can find. With practice you'll get the hang of it.

Hope this is what you are after.

Regards