Show all Date Dimension Values regardless the data values

[shyamcharan]

Hi Experts,

I have a scenario where I need to show the date values(using drill down object from year, month, etc)  on the X-axis regardless of the data values for a particular Asset or Product.

Please find the attached QVW where I have made a selection on Product ID(P44) but the graphs shows data only for 2 months but I would like to see all months irrespective of the data.

Can someone please help me understand how this can be achieved. Moreover, all the source tables are from SQL server database.

So will have to script in DB or in Qlikview?

Thanks heaps in advance.

[#2]

Hi shyamcharan,

PFA,

For SQL DB tables you need fire query with respective table names which u have,

ex.

your sql connection string required for loading data from sql tables;

you can achieve it by creating ODBC or OLEDB connector...

[Your ConnectionString];

Sql select * from tablename; -or-

Sql select * from viewname; -or-

Directly place query under ConnectionString to load data;

[mohammadkhatimi]

Hie...

Try this:-

sum({1<FiscalYear=>}[Sales amount])

Hope its helps you

Regards,

Er. Mohammad

[shyamcharan]

Hi Harshal,

Your solution will not work for me as the graph would have thousands of Assets and if the graph does not show the Cost for one asset rather show the Cost for all Assets its very confusing and not good with too many lines on it.

Thanks,

Shyam

[shyamcharan]

Hi Mohammad,

My requirement should work many other filter/list boxes. not just one.

Regards,

Shyam.

[#6]

Hi,

Do you have any sample image for your layout representation please share if you have else create drill-down group ,

chart properties>dimension>Edit Grp.>Edit>drill-down with respective date fields & put created grp. in dimension.