topic Re: How to resolve this in QlikView

How to resolve this

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am facing a strange issue. Loading an excel file in the app. I have monthstart field in excel value-10/1/2016; have second FieldB. I have a straight table using Monthstart as dimension and FieldB as expression. The straight table is empty. Both fields are coming in list boxes but straight table is blank unless I select a value from listbox. Anyone gone through this?

Thanks.

Re: How to resolve this

Anil_Babu_Samineni — Tue, 06 Dec 2016 01:50:46 GMT

How fieldb values are looking

Try =only(fieldb) and uncheck the radio button with no totals

Re: How to resolve this

sunny_talwar — Tue, 06 Dec 2016 02:01:39 GMT

What is your expression? Would you be able to share a sample or screenshots of your expression and dimension?

Re: How to resolve this

Anonymous — Tue, 06 Dec 2016 03:11:41 GMT

Attached pls find the excel and qvw. I want to create stacked bar chart where Type is dim. For each Type, Mobile, Store etc, I need Sales and Return stacked. I need this for July and August. so there will be total 6 bars (2 for ea month). Each bar will have 2 metrics stacked inside. I tried creating one but not coming through. Thanks in advance.

Re: How to resolve this

sunny_talwar — Tue, 06 Dec 2016 03:28:05 GMT

You need this?

Re: How to resolve this

Anonymous — Tue, 06 Dec 2016 03:50:16 GMT

Hi Sunny Thanks for the quick reply. I m actually pointing the qvw to Nprinting. The way it workd in Nprinting is that the table has to have one dim and (n) expns. your chart has 3 dim (Type, Month, Transaction Type) and one expn. When I embed the qvw table in Nprinting to output a report, it does not work. I was thinking of ways where I can have a straight table with 1 dim but multiple expns so that it can pass thru Nprinting. I will post more.

Re: How to resolve this

Anonymous — Tue, 06 Dec 2016 03:52:11 GMT

btw how did you get the field TransactionType in the script?

Re: How to resolve this

sunny_talwar — Tue, 06 Dec 2016 03:54:51 GMT

‌CrossTable load

Re: How to resolve this

Anonymous — Tue, 06 Dec 2016 17:46:34 GMT

I was trying to understand the logic behind CrossTable(TransactionType, Value, 2)

Are we putting Value and 2 because there are 2 expressions (Sales and Return)..?

Re: How to resolve this

sunny_talwar — Tue, 06 Dec 2016 18:04:22 GMT

2 because we don't want the first two columns to be not transposed

tab:

CrossTable(TransactionType, Value, 2)

LOAD Month,

Type,

Sales,

Return

FROM sample.xlsx (ooxml, embedded labels, table is Sheet1);

Re: How to resolve this

Anonymous — Wed, 07 Dec 2016 03:44:36 GMT

Hi Sunny I edited the excel feed to outline rounding off problem I am having. can you help me round off the values inside bars to Bil. For eg I want 456,495,000,000 to be shown as 456.5 Bil. I tried rounding off the field 'Value' at expn level but did not work. I have attached the qvw and updated excel sheet.

To get the values inside, I went to present tab ----> and then checked Plot Values inside segments.

As always, Many Thanks.

Re: How to resolve this

Anil_Babu_Samineni — Wed, 07 Dec 2016 04:20:23 GMT

Check this

I done this

Enclosed Attached

Re: How to resolve this

sunny_talwar — Wed, 07 Dec 2016 09:36:53 GMT

or you can use this expression:

=Round(Sum(Value), 0.1)

With Expression Default on Number's tab

Re: How to resolve this

Anonymous — Wed, 07 Dec 2016 13:11:48 GMT

when I opened your app it did not work it still did not round up the numbers. Pls see the image below.

Re: How to resolve this

Anonymous — Wed, 07 Dec 2016 13:26:14 GMT

pls see the attached qvw. It did not work.

Re: How to resolve this

sunny_talwar — Wed, 07 Dec 2016 13:26:44 GMT

Check now

Re: How to resolve this

Anonymous — Wed, 07 Dec 2016 13:36:45 GMT

That worked. however the 'Bil' Y axis label went away. is there a way to use Bil symbol for Y axis?

Re: How to resolve this

Anil_Babu_Samineni — Wed, 07 Dec 2016 13:51:37 GMT

I've opened your application. It went well. Are you referring 7th/Jan and 8th/Jan Date of values. If so, That is the problem with Width and Height.

I had seen reply to Sunny T, Can we know where you want to show the Bil Name for Y-Axis

And i would recommend to change plot values from Inside to Normal and then use Only one value from One graph on each segment. In that, You will get pop-up for users as well

Re: How to resolve this

sunny_talwar — Wed, 07 Dec 2016 13:54:11 GMT

Here you go

Re: How to resolve this

Anonymous — Wed, 07 Dec 2016 13:58:32 GMT

Ha! I tried with Million and Billion Symbols but left that one out.

Thanks so much