topic Data scenario in QlikView

Data scenario

reshma_km — Thu, 26 Nov 2015 09:26:47 GMT

Hi,

My data set has 5 year data.

I have 5 measures - 3 measures have data for whole 5 years; 2 measures have data only for 2 months.

When these 5 measures are plotted in a bar chart, how can we make sure the 5 measures are being displayed correctly? Is there any Qlikview feature for that?

Re: Data scenario

swuehl — Thu, 26 Nov 2015 21:30:24 GMT

What do you mean with 'displayed correctly'? What is your requested result for the bar chart?

And what is the dimension of the bar chart?

If possible, please upload a small sample QVW and your requested result of the bar chart (e.g. as a sketched drawing).

Re: Data scenario

reshma_km — Fri, 27 Nov 2015 05:36:03 GMT

This is an interview question. Actually, I also didn't understand what does it mean. So I thought of posting it here.

Re: Data scenario

Anonymous — Fri, 27 Nov 2015 05:57:03 GMT

Say, Sales is one of the measure which have 2 months data only...

Very simple, When user select any of the month out of those 2 month, he will get the sales value else no data.

What exactly you want?

Re: Data scenario

Kushal_Chawda — Fri, 27 Nov 2015 06:10:09 GMT

You can display the values on bar chart for all the measures but it depends on the what dimension you are using. As swuehl‌ suggested please clarify which dimension you are using

Re: Data scenario

nagarjuna_kotha — Fri, 27 Nov 2015 06:14:35 GMT

Hi Reshma,

Can you share sample data and expected output??

Regards,

Nagarjuna

Re: Data scenario

nagarjuna_kotha — Fri, 27 Nov 2015 06:30:40 GMT

Hi ,

As per your question we can can show like below attached.

Re: Data scenario

Anonymous — Fri, 27 Nov 2015 13:09:43 GMT

Sometimes we gets afraid, ohh what should I answer for this question? Most of the time people see your confidence and Intelligency with tool.

And you need to clear, simpler and cool to answer those kind of questions