topic Re: Straight table chart in QlikView

Straight table chart

bharatkishore — Tue, 31 Oct 2017 06:32:38 GMT

Hi All,

I am facing an issue with the dimension in the chart.

I have a straight table chart and in that chart and i have one dimension called cat and some set analysis expressions: All the values are coming fine. Below image for reference:

But now i need to add two more dimensions called Month and Month-Year and the it should only show data starting from Jan 2017: Below image for your reference:

If i add these two dimensions in the first chart it is not working because there are some set analysis expressions written,

But i need to show it in the format of second chart.

Attached qvw for more reference.

Values should be same which are in first chart..

Please let me know if you require anything more.

Thanks,

Bharat

Re: Straight table chart

mdmukramali — Tue, 31 Oct 2017 07:57:04 GMT

Hi Bharat,

Use Calculated Dimension:

=if(Year(MonthYear)>='2017',[Month-Year])

find the attached app for more info.

Thanks,

Mohammed Mukram.

Re: Straight table chart

sunny_talwar — Tue, 31 Oct 2017 08:47:27 GMT

Not sure if I completely understand the issue here? Would you be able to elaborate a little bit more?

Re: Straight table chart

bharatkishore — Tue, 31 Oct 2017 13:04:32 GMT

Hi Sunny,

I will try to explain bit clearly..

First i have developed all the required expressions in the chart, image for your reference:

Now i need to calculate next items say IB Start1

The formula for IB Start1 is same expression for IB end

Now for Aging 1 formula is Expression of IB Start1 /12 and the value for h)Morethan7year should be 0

Now for cons 1 the formula should be Aging1 exp *

(sum({<Year={">=$(=Max(Year)-2) <=$(=Max(Year)-1)"},Month={">=$(=Max(Month)-12) <=$(=Max(Month))"}>}Consumption)/

sum({<Year={">=$(=Max(Year)-2) <=$(=Max(Year)-1)"},Month={">=$(=Max(Month)-12) <=$(=Max(Month))"}>}SystemYr_sql))

Attached excel and qvw for more formulas and reference..

I am not sure whether i m following correct approach if not please let me know.

Thanks,

Bharat

Re: Straight table chart

sunny_talwar — Tue, 31 Oct 2017 13:11:36 GMT

You Excel have a lot of charts, which one are we looking at... To me it seems that you QlikView chart is working as you want, still not sure what is the issue? Can you pinpoint a specific issue?

Re: Straight table chart

bharatkishore — Tue, 31 Oct 2017 13:18:57 GMT

Hi Sunny,

In Excel it is from line no 54..

In qlikview i have taken dimensions Cat .. and in exp i have calculated IB Start, Aging , Cons, New IB and IB end for Jan month if you see all the values will be matching..

But from Feb i have calculated in the name of IB Start1, Aging 1, Con1 and these values are also matching , But i donno how to create New IB and IB end for Feb.. I have sent because thought u will get better understanding for all the formulas..

And these all i need to calculate for 12 months.. so i donno whether my approach is correct or not..

Please let me know if you need anything more..

Thanks,

Bharat

Re: Straight table chart

bharatkishore — Tue, 31 Oct 2017 14:25:20 GMT

Hi Sunny,

Please let me know if something is not clear..

I will try to explain more..

Just a small question can we get the desired output like how we have in excel.. please let me know.. sorry to take ur time...