Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

shyamcharan
Contributor III

Show all Date Dimension Values regardless the data values

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.

5 Replies
Not applicable

Re: Show all Date Dimension Values regardless the data values

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;

Partner
Partner

Re: Show all Date Dimension Values regardless the data values

Hie...

Try this:-

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

Hope its helps you

Regards,

Er. Mohammad

shyamcharan
Contributor III

Re: Show all Date Dimension Values regardless the data values

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
Contributor III

Re: Show all Date Dimension Values regardless the data values

Hi Mohammad,

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

Regards,

Shyam.

Not applicable

Re: Show all Date Dimension Values regardless the data values

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.