Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

do we have straight table in qliksense

hi ,

Kinldy Help Me ,can any one tell me do we have Straight table in qliksense.. either Any Extension for the same.

I m Using simple Either Dynamic table for Dimension and Measure but Problem is that all dimension show all value.

its not showing measures based value in there Column..

6 Replies

Re: do we have straight table in qliksense

Sort of. You can use Table object and add Dimensions and Measures to it, just like you use dimensions and expressions in a Straight Table in Qlikview.

but Problem is that all dimension show all value.

Can you explain what you mean?


talk is cheap, supply exceeds demand
Not applicable

Re: do we have straight table in qliksense

but Problem is that all dimension show all value. ( It Means Say example...

in Dimension i have a Date Field and expression have Sum(Sales)... so if i m taking Table object

it shows All Date like

   DATE                       SALES

01/01/2015                      500

02/01/2015                        -

03/01/2015                      100

04/01/2015                      200

05/01/2015                       -

ogster1974
Honored Contributor II

Re: do we have straight table in qliksense

Create a new dimension that looks for only dates that have sales against them.  I did this by creating a master dimension in the attached example and called it sales date.

SalesDate IF(AGGR(SUM(SALES),[DATE])>0,[DATE],NULL())

This excluded the dates that had no sales against them.

When I brought this into my table I unticked the show null values.  this hide the null dimension values from my view.

Regards

Andy

Re: do we have straight table in qliksense

Hi, in QlikView by default is checked the option to 'Supress zero values'

In Qlik Sense by default is checked the option to 'Show zero values', if you uncheck this null and zero values will disappear.

Not applicable

Re: do we have straight table in qliksense

But can any on tell me If i have More than 15 Dimension and Measure in Total.. its not showing value after 15 Column

ogster1974
Honored Contributor II

Re: do we have straight table in qliksense

You've lost me.  The solution I proposed meets your objective as described to remove dates with null sales values from a simple table.  Is this a new requirement?  if yes provide more detail (perhaps a screen shot) in a separate question and mark this question as closed if that has been answered.

Regards

Andy 

Community Browser