How to create straight table without expression in QlikSense

[ankitasinghal]

Hi Geeks,

Good evening!!

I have requirement in which i only have to show dimension.i tried 2-3 solution to show only dimension in table /pivot in qliksense.

requesting you to help me to create table/pivot without expression in qliksense.

Thanks,

Ankita

[wdchristensen]

Can you provide an example of your input and your desired output?

[agigliotti]

I guess you can't use pivot table with no measures.

Instead you can use table for your needs.

However as wdchristensen‌ said above, what's your goal ?

[krishna20]

Hi Ankita,

If you want to display only dimensions ,you can show those in table box without any expressions.

[Chanty4u]

simply add dimensions in table  in qliksense

if you want measure as dimension means use like below

=aggr(sum(sales),ID)