Discussion Board for collaboration related to QlikView App Development.
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?
How fieldb values are looking
Try =only(fieldb) and uncheck the radio button with no totals
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.
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.
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)..?
2 because we don't want the first two columns to be not transposed
CrossTable(TransactionType, Value, 2)
FROM sample.xlsx (ooxml, embedded labels, table is Sheet1);