topic Straight Table Issue in QlikView

Straight Table Issue

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

Hello,

I have table like below

LOAD * INLINE [

Country, Sales

India, 5000

Us, 2500

Uk, 4000

India, 5000

Us, 5500

India, 4500

];

So, Now i want to show Straight table like below

Country	Sales
India	5000
India	5000

Note: Please send me the Expression using Set Analysis ....

Please help me, I Appreciate your Help ..

Re: Straight Table Issue

tamilarasu — Fri, 27 May 2016 07:47:09 GMT

Use RecNo() function in your load script. Add the Recno column in straight table and go to presentation tab then hide it. Check the attachment for better understanding.

Load *, RecNo() as RecNo;

LOAD * INLINE [

Country, Sales

India, 5000

Us, 2500

Uk, 4000

India, 5000

Us, 5500

India, 4500

];

Re: Straight Table Issue

Anil_Babu_Samineni — Fri, 27 May 2016 07:54:27 GMT

Tamil,

Thanks for Attempting..

I want to show o/p like below, Please review my required O/P

Country Sales

India 5000

Here, I don't want to show 4500 Data....

Updated : My Client allowed to show Duplicates as well ....

Re: Straight Table Issue

Anonymous — Fri, 27 May 2016 07:54:39 GMT

Hi Anil,

I guess Country is the dimension. You can make it calculated dimension similar to

If(Country = 'India', Country)

Good Luck

Re: Straight Table Issue

Anonymous — Fri, 27 May 2016 08:01:15 GMT

Oh, I forgot the 4500 row ... then the Expression for Sales might be if(Sales > 4500, Sales) ...

... or probably Sum({<Sales = {'>4500'}>} Sales)

Re: Straight Table Issue

tankut_kocabas — Fri, 27 May 2016 08:11:11 GMT

Hi,

You can try this

Temp:
LOAD * INLINE [
Country, Sales
India, 5000
Us, 2500
Uk, 4000
India, 5000
Us, 5500
India, 4500
];

Temp1:
NoConcatenate LOAD Country, Sales
Resident Temp
WHERE Country = 'India';

DROP Table Temp;

Re: Straight Table Issue

tamilarasu — Fri, 27 May 2016 08:19:18 GMT

ANil,

Check the attachment.

Re: Straight Table Issue

HirisH_V7 — Fri, 27 May 2016 08:25:17 GMT

Hi,

May be these ways,

Dimension:

      =IF(Match(Country,'India'),Country)

Expression:

        =IF(Sales<>'4500',Sum(Sales))

Only expression:

Sum({<Country={'India'},Sales-={'4500'}>}Sales)

Can You please elaborate your requirement do you require the values above 5000 for india or what you can specify that condition in the expression itself or in script itself you can handle it using where condition.

Hope this Helps,

PFA,

Hirish

Re: Straight Table Issue

Anil_Babu_Samineni — Fri, 27 May 2016 08:25:20 GMT

Tamil,

Perfect..

Sometimes, Client need only India data.

Note: They can allow Duplicates as well.

My task is finished. Do favor for me..

I want to show like this

Country Sales

India 5000

India 4500

Re: Straight Table Issue

Fri, 27 May 2016 08:38:14 GMT

Hi,

See the attached.

Re: Straight Table Issue

qlikview979 — Fri, 27 May 2016 08:38:52 GMT

Try like this

sum({<Country={'India'}>}Sales)

Re: Straight Table Issue

tamilarasu — Fri, 27 May 2016 10:26:35 GMT

Anil,

Sorry for the late reply, I was busy with work. Please check new attachment.