topic Re: Data Issue in QlikView

Data Issue

nihhalmca — Tue, 27 May 2014 08:37:31 GMT

Hi All,

I got one ticket on existing dashboard, it is new to me so i am seeking your assistance.

Pivot table has 10 columns and it display data in dashboard. However if i take selections on Year and Quarter 2 columns are shown 0 values rest of 8 columns shows data. i can understand it is not enough to solve issue but i can not explain detail (new application to me). Please suggest me.

Thank you.

Regards,

Nihhal.

Re: Data Issue

ThornOfCrowns — Tue, 27 May 2014 08:39:19 GMT

Your best bet is to post the qvw with some dummy data if neccessary, as it's much easier to see the problem that way.

Re: Data Issue

jagan — Tue, 27 May 2014 08:48:43 GMT

Hi Nihhal,

What are the expressions using in that 2 columns? It is very difficult to say without the sample file, attach some sample file. If the file you are working is of confidential then scramble the numbers and then share. You can scramble the data by using

Document Properties -> Scrambling -> Select the field and click on Scramble button.

Regards,

Jagan.

Re: Data Issue

nihhalmca — Tue, 27 May 2014 09:09:21 GMT

Expression is simple as sum(amount)

Re: Data Issue

nihhalmca — Thu, 05 Jun 2014 05:53:49 GMT

Hi Jagan, thanks for writing and i resolved this issue with help of teammate.

thanks,

Nihhal.