Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

deepak_km9886
Contributor

Tableau expression in Qlik sense

`{ fixed [Customer Number]: if COUNTD([Order Number])>25 then 'Frequent Shoppers' Else 'Non-Frequent Shoppers' END}`

I have this expression in tableau. It is counting the order number greater than 25 for each customer number. Customer number and order number are the two columns in the table XYZ. What would be the expression for dimension in qlik sense ? Frequent and non frequent shoppers are  just a declared in text

Tags (2)
6 Replies

Re: Tableau expression in Qlik sense

May be this if you have Customer Number as the dimension:

If(Count([Order Number]) > 25, 'Frequent Shoppers', 'Non-Frequent Shoppers')

Else may be this in a list box object:

Aggr(If(Count([Order Number]) > 25, 'Frequent Shoppers', 'Non-Frequent Shoppers'), [Customer Number])

deepak_km9886
Contributor

Re: Tableau expression in Qlik sense

Frequent shoppers an d non frequent shoppers are just text field in tableau

Frequent Shoppers

Role:

Discrete Dimension

Type:

Calculated Field

Contains NULL:

Unknown

Locale:

Sort flags:

Case-sensitive

Column width:

Unknown

Status:

Valid

Formula

'Frequent Shoppers'

The domain for this field has not been loaded. Click "Load" to retrieve.

This is the description of frequent shoppers and similarly ir goes foe non frequent shoppers

Re: Tableau expression in Qlik sense

I guess my question is how do you plan to use this new field or expression? In a table or as a filter? What is the intent here?

Highlighted
arusanah
Contributor II

Re: Tableau expression in Qlik sense

hey sunny ,

looks like you worked on tableau too.  I needed help converting two of my Qlik expressions to tableau. Can you help . please !!!

deepak_km9886
Contributor

Re: Tableau expression in Qlik sense

Where is the expression? Just leave the expression here. Ill get it out

preetam16
New Contributor

Re: Tableau expression in Qlik sense

How can I implement the below Tableau LOD Expression in Qliksense?

{Fixed , ,   , : Sum([Sales])}

where A, B, C, D, E are all dimensions.

Also, please let me know what it does exactly. Thanks.